Reading Time: 2 minutes One of the key advantages of Power BI is the ability to create powerful custom measures in your data models using the Data Analysis Expressions (DAX) language. DAX allows users to create complex calculations based on…
Read MoreTag: DAX
Tableau to Power BI: Running Total and Other Running Calculations
Reading Time: 6 minutes One of the conveniences of Tableau is the ability to easily create “running” totals or other aggregations. These table calculations can be handled through the user interface. One of the questions that I sometimes receive from…
Read More
Manual Groups and Bins in Power BI: Why and How
Reading Time: 6 minutes When needed, Power BI offers the ability to create Groups and Bins to help consolidate data into a more presentable or meaningful visualization. The documentation has more detail and walks through the process of creating Groups…
Read More
Tableau to Power BI: INCLUDE Level of Detail Expressions
Reading Time: 4 minutes In Tableau, INCLUDE level of detail (LOD) expressions are used to obtain values for dimensions that are not directly used in a visualization. This final LOD post focuses on adapting Tableau INCLUDE LOD expressions to DAX…
Read More
Tableau to Power BI: EXCLUDE Level of Detail Expressions
Reading Time: 4 minutes In a recent post on Tableau level of detail (LOD) expressions, I explored a method to translate FIXED to DAX in Power BI. Continuing that theme, I’ll now attempt to show an equivalent for the EXCLUDE…
Read More