Power BI

The DAX OFFSET function has been talked about for a while now. The main entry point to this function for almost everyone was the article by Marc Lelijveld How to OFFSET in DAX would make your life easier – Data – Marc (data-marc.

There are new DAX functions: INDEX, OFFSET, and WINDOW. These functions allow us to compose powerful filter tables that have not been possible before or at least require very complex DAX code. These functions come with additional clauses, namely ORDERBY and PARTITIONBY. PARTITIONBY enables the partitioning of a virtual table.

Contribute to PBI-David/Deneb-Showcase development by creating an account on GitHub.

Shared via Flipboard

We cannot apply conditional formatting for line charts in Power BI to control the colors of the lines. But sometimes we want to fix these colors. Let’s see how we can do it.In my previous article, I …

Microsoft Graph toolkit is amazing, but unfortunately not available for Power Apps - Let's fix that!

I started my Power Apps blog in June 2020 with no expectations. All I wanted was a place where I could write about the cool things and to document best practices.

In this post, we examine how personal data can be used in personal projects to help us learn Power BI.

Bug-free development with BDD. ✓ Automate tests in your native language ✓ by using the easy to understand Gherkin syntax. ✓ for .NET.

Being able to construct DAX queries dynamically in C# means the possibilities are endless in terms of integrating Azure Analysis Services queries into your custom applications, and with the code samples in this post, you have everything you need to get started.

An introduction to the basic syntax of Rel.

Despite being inherently difficult to test, the need to validate data modelling, business rules and security boundaries in Power BI reports is important, as well as the need for ensuring that quality doesn't regress over time as the insights evolve. This post explains that, by connecting to the underlying tabular model, it is possible to execute scenario-based specifications to add quality gates and build confidence in Power BI reports, just as any other software project.

With a variety of integration support through client SDKs, PowerShell cmdlets and REST APIs, it can be hard to know where to start with integrating Azure Analysis Services into your custom applications. This posts walks through the options, and lays out a simple guide to choosing the right framework.

One of the first steps in integrating Azure Analysis Services into your applications is creating and opening a connection to the server - just like any other database technology. This post explains the ins and outs of creating Azure Analysis Services connections, including code samples for each of the key scenarios.

Metrics layer is the rising “missing component” of the modern data stack. I dive into functionalities provided by 10 prominent players in the space and contrast them with a player no on…

Our cool new house needs one more plank in its foundation.

I often get asked which tool or language I would recommend for creating data visualizations. Like many responses in the world of technology (and perhaps the world in general as well), the answer is almost always "It depends.

Text is the most under utilized tool in visuals. Few days ago I saw a post by Christopher Chin where is showed a unique way to show legend in a visual, and I was trying to figure out how to recreate it in PowerBI such that it is dynamic(change with filter) and show different color is a single text.

Metrics layer is the rising “missing component” of the modern data stack. I dive into functionalities provided by 10 prominent players in the space and contrast them with a player no on…

This is the second installment in our two-part series on DAX window functions announced in the December 2022 release of Power BI Desktop. I will first answer the questions that I had received from …

The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL wind…

Reading Time: 4 minutes The Power BI Gen2 capacity model significantly changed the way that Power BI resources are shared among multiple or reserved for individual customers. Attempting to draw a good analogy of how capacities work, however, leads to significant oversimplification. Simple analogies...

Why using a column from a large fact table as a dimension could result in errors in Power BI DirectQuery mode

I love Excel as an alternative to Power BI reports, especially now that Excel Online allows you to interact with browser-based Excel reports that use Power BI datasets or the Excel Data Model (aka …

Thoughts on why Power BI is a semantic layer and a metrics layer

This video explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool.

The filter arguments in CALCULATE can be written as logical conditions with certain restrictions. This article explains the more common errors in these cond

In early 2022, Microsoft released a new activity in Azure Data Factory (ADF) called the Script activity. The Script activity allows you to execute one or more SQL statements and receive zero, one, …