Tag: SWITCH TRUE Statement

Dummy Variables: How To Use Them To Write Smarter DAX

Dummy Variables: How To Use Them To Write Smarter DAX

In this tutorial, I’ll be talking about how to use dummy variables in writing better DAX measures. This is especially applicable in cases where more complex DAX is needed. Using this technique, you can be more flexible in dealing with different variables and conditionals. You may watch the full video of this tutorial at the

Continue reading

Data Visualization Technique | Power BI Dynamic Visuals

Data-Visualization-Technique-_-Power-BI-Dynamic-Visuals

I want to show you a data visualization technique that I believe is one of the best that you can do in Power BI. There are so many techniques now compared to when I first created this technique, but to me, this still has a lot of positives to it and it can really showcase

Continue reading

Power BI Holiday Calendar – Calculate Date W/DAX

Creating a Power BI holiday calendar is crucial for many time intelligence calculations. In this tutorial, I’m going to show you how to calculate specific holiday dates using DAX measures. You can watch the full video of this tutorial at the bottom of this blog. This example came from one of the Enterprise DNA initiatives

Continue reading

How To Create Unique Subtotals In Power BI Tables

How To Create Unique Subtotals In Power BI Tables

In this tutorial, I’m going to show you how to create unique subtotals in your Power BI tables using the SWITCH TRUE logic. You may watch the full video of this tutorial at the bottom of this blog. This is a breakout session from a financial reporting course released by Enterprise DNA. The session includes

Continue reading