Power BI

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection

If you want to show the ranking in a Power BI visual, one way is to use a visual that supports that, such as a Ribbon chart. Another way, which is a more common way, is to write a calculation for rank, and RANKX is a DAX function that can help you with that. In Read more about Showing Ranking in a Visual in Power BI using RANKX DAX function[…]

This article describes a very common optimization pattern that relies on variables to optimize conditional expressions in DAX. In a previous article we show

Learn how to write calculations in Power BI for comparing values of a month with the month before and get variance and percentage.

learn how to use TopN function in DAX either to create a calculated table, or to use it in a measure to achieve analysis such as; comparison with the average amount of the top group.

Learn how to filter the data for a calculation in a DAX expression in Power BI. You can apply multiple conditions using AND or OR operators.

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you like to follow best practices, you can just read this paragraph out of the entire article. If you are using SUMMARIZE to calculate new columns, s

Learn how to get a field's value from another table in Power BI using the Related function in DAX and traversing through the existing relationship

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you

Evaluation context is the most important concept to understand in DAX . This context is used when evaluating expressions to get to the result.

Power BI Calculation groups can solve data modeling challenges in a clean easy way, like a table filtering two dimension tables without model relationships

Learn how to use the RELATEDTABLE function in DAX and Power BI to get a subset of rows from a related table

Power BI has the built-in feature of creating binning for a numeric field such as age. However, the default binning will create bins of equal size. If you want to create bins of different sizes, then …

Time to read: 4 minutes Calculation groups is a powerful feature in Power BI. However, using them adds some complexity and brings some limitations to Power BI’s native functionality. Or... Read more »

Dev Consultant Jean Hayes spotlights Data Analysis Expressions (DAX) with Calculation Groups. Power BI Premium (Preview), Azure Analysis Services and SQL Server Analysis Services 2019 now support Calculation Groups! Why am I so excited? Because this functionality was one of the best capabilities in Multidimensional Analysis Services through Named Sets and Calculated Members.

Calculation groups can apply specific calculations onto existing DAX measures. For example, calculation groups can implement time intelligence calculations

C# scripts are great to automate tasks which are repetitive but have some customization for each model

Calculated tables are not used often, because after all, it only combines data that you already have, right? Well, I didn't use them often, until recently...

Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the sel

Learn how to push your report level measures into your tabular model!

ADDCOLUMNS: Returns a table with new columns specified by the DAX expressions. https://dax.guide/addcolumns/

In this article we show some techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. P

In a previous story, I explained some details about Semi-Additive Measures. Here are some more hints on this topic

A client had a problem with his report. I was asked to find the issue and solve it. This is the story about it

In this tutorial, I’d like to discuss how you can improve your creativity when creating custom visual reports in Power BI. I highly recommend creating projects that are outside your organization’s environment. This is because when creating projects for your organization, your creativity is limited. M

DAX is simple, but it is not easy. I cannot remember how many times I read this sentence on social media, attributed to me. For good reason: I have repeated

This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might displ

Bottom N Analysis in Power BI

I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s [...]Read More »