Tag: DAX Formulas

Power BI DAX Measures For Events In Progress

In this tutorial, I’m going to show you how to create Power BI DAX measures for events in progress. These events could come in the form of orders in progress or sales in progress, depending on the nature of your report. Basically, the challenge here is calculating results when there is more than one date

Continue reading

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

Power BI USERELATIONSHIP vs TREATAS

Power-BI-USERELATIONSHIP-vs-TREATAS

I’m going to show you the difference between the Power BI USERELATIONSHIP function and the TREATAS function that are both used when creating DAX measures. You may watch the full video of this tutorial at the bottom of this blog. I got this tutorial idea from a question that was raised on the Enterprise DNA

Continue reading

Inventory Dashboard Using Basic DAX In Power BI

Inventory Dashboard Using Basic DAX In Power BI

In this tutorial, I’m going to show you how to create a great inventory dashboard using some DAX formulas in Power BI. After properly setting up the data model, the next step is to write the DAX formulas and set up the visualizations for an inventory system in Power BI. This tutorial will show the

Continue reading

DAX Variables And Comments To Simplify Formulas

Simplify DAX Formulas Using Variables And Comments

In this tutorial, we’re going to discuss the easiest way to simplify DAX formulas using variables and comments in Power BI. DAX codes can become complex and hard to comprehend once they get more advanced. If we don’t optimize them, other Power BI users within the organization will have a difficult time understanding the data

Continue reading