Get a field value from a related table in Power BI: DAX RELATED Function Explained

Posted on June 8, 2021June 8, 2021 by Reza Rad

Sometimes, in Power BI, you need to access a field’s value from another table that somehow is related to the existing table. You can use Power Query transformations such as combining Merge with something else. However, this can be needed when you write a DAX expression too. In this article and video, I explained a Read more about Get a field value from a related table in Power BI: DAX RELATED Function Explained[…]

Document the Power BI Tenant objects: Workspace, reports, datasets, dataflows with no code

Posted on June 4, 2021June 4, 2021 by Reza Rad

Previously I explained how you can document a single Power BI file. Another very common documentation requirement is to find out what objects, workspaces exist in the Power BI tenant and document them all. even you may want to download all the PBIX files from the service and keep it for versioning purposes. In this Read more about Document the Power BI Tenant objects: Workspace, reports, datasets, dataflows with no code[…]

FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations

Posted on June 3, 2021June 3, 2021 by Reza Rad

You can apply filtering to visualization elements. However, sometimes filtering has to be done on specific calculations. This can come in handy especially when you want to compare values of other items with specific items. In this article and video, I’ll explain how to use the FILTER function in DAX to apply a custom filter Read more about FILTER Function in DAX and Power BI: Apply Custom Filter to Calculations[…]

How to Reduce the Size of Power BI file in a few Steps

Posted on June 2, 2021June 2, 2021 by Reza Rad

One of the performance considerations of a Power BI file is to reduce the size of it as much as possible. This also helps with the speed of development, because smaller files loads faster and easier in the Power BI Desktop. One way to reduce the size significantly is to find which columns are consuming Read more about How to Reduce the Size of Power BI file in a few Steps[…]

Month over Month Calculation in Power BI using DAX

Posted on June 1, 2021June 1, 2021 by Reza Rad

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

Export the Data of a Power BI table entirely in a few Clicks

Posted on May 31, 2021May 31, 2021 by Reza Rad

If you want to export the data of a Power BI table, you have options such as copy and paste, or putting it in a visual and export it. However, there is an easier way available too. You can use Power BI Helper (free tool) to export the entire data of the table. The instruction Read more about Export the Data of a Power BI table entirely in a few Clicks[…]

Document a Power BI file and report in a few clicks: all DAX code, visualization, Power Query scripts

Posted on May 28, 2021May 31, 2021 by Reza Rad

In this article and video, I’ll share with you how to document everything from a Power BI file in a few clicks. The document output will have all the DAX code (measures, columns and tables) with the expressions, the tables with the Power Query scripts, information about visualization such as how many pages, bookmarks, visuals Read more about Document a Power BI file and report in a few clicks: all DAX code, visualization, Power Query scripts[…]

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

Posted on May 27, 2021May 27, 2021 by Reza Rad

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

Posted on May 26, 2021May 26, 2021 by Reza Rad

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

Posted on May 20, 2021May 20, 2021 by Reza Rad

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