Power BI

Sum the visible values of a table in Power BI

Previously I explained the AddColumns function as a function that adds one or more columns to the existing table, In this article and video, I’ll explain another similar and useful function with slightly different behavior: SelectColumns, and you will learn how you can use it in Power BI and DAX. SELECTCOLUMNS is a Tabular function Read more about Create a subset of the table in Power BI and add calculations using SELECTCOLUMNS DAX Function[…]

This article describes the differences between eager evaluation and strict evaluation in DAX, empowering you to choose the best evaluation type for your data models. A conditional expression in DAX – like an IF function – can be evaluated in two ways: eager and strict. Understanding the difference be

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