Tag: DAX Formulas

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

DAX Formula Writing Techniques In Power BI

DAX Formula Writing Techniques In Power BI

In this tutorial, we’ll talk about DAX formula writing techniques and how to simplify models in Power BI. We’ll discuss the key functions and methods to organize and make our model’s interface friendlier and easier to operate. The methods we’re going to go through are formula syntax, measure groups, and formatting DAX codes in Power

Continue reading