Month over Month Calculation in Power BI using DAX

When working with dates, one of the common types of analysis is period vs period, such as Year over year, and Month over month. In this article and video, I’ll explain how you can use DAX to write calculations for month-over-month simply in any Power BI report. Video What is a month-over-month calculation? Month over Read more about Month over Month Calculation in Power BI using DAX[…]

TOPN DAX Function: How it works in Power BI? Comparison against the top group

TOPN is a function in DAX that gives you the ability to select the top items from a table based on an expression. In this article and video, I’ll explain how to use the TopN function in DAX either to create a calculated table or to use it in a measure to achieve analysis such Read more about TOPN DAX Function: How it works in Power BI? Comparison against the top group[…]

Showing Ranking in a Visual in Power BI using RANKX DAX function

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[…]

Create a subset of the table in Power BI and add calculations using SELECTCOLUMNS DAX Function

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[…]

How to use AddColumns function in DAX and Power BI

AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in Read more about How to use AddColumns function in DAX and Power BI[…]

Day of Year and Day of Quarter – DAX calculations for Power BI

Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI[…]

Aggregation to speed up the performance of a Power BI report even if all IMPORTED

One of the questions I normally get after presenting about aggregations in Power BI is that, does the aggregation works only for Composite mode and in scenarios to speed up the DirectQuery? or does it work in import mode as well? This article is about this question and shows how you can speed up your Read more about Aggregation to speed up the performance of a Power BI report even if all IMPORTED[…]

Dynamic Row-Level Security in Power BI with Exclude and Include Rules

In the previous article, I explained how to implement a dynamic row-level security pattern when you have a value that you want to exclude. However, what if you want to EXCLUDE at some scenarios and INCLUDE in some others? What if you want to have a role saying access to everything but New Zealand, and Read more about Dynamic Row-Level Security in Power BI with Exclude and Include Rules[…]

Dynamic Row-Level Security in Power BI with NOT IN or NOT EQUAL Rule

Sometimes when you apply the dynamic row-level security, you want to have the criteria as NOT EQUAL and NOT IN. This can be a bit tricky in the dynamic implementation of RLS, because the relationship behavior is normally the opposite. In this article I’ll explain how you can do that. Introduction I have written many Read more about Dynamic Row-Level Security in Power BI with NOT IN or NOT EQUAL Rule[…]

Dynamically change the format of values in Power BI

Can you change the format of a measure or a value in Power BI dynamically? Is it possible to set a value to be a percentage sometimes, and sometimes to be a currency? can you change the currency format? The answer to all these questions is yes. In this short blog, I am going to Read more about Dynamically change the format of values in Power BI[…]