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
Tag: Variables DAX
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
Today, we are diving into what you could do in the Power BI formula bar in terms of syntax, comments, and variables. These are all very important techniques that you could use in your work patterns. But before we jump into Power BI formulas, I’ll show you how I sort my Dates column within my
In this tutorial, we’re going to learn how to create a currency conversion table for Sales in Power BI using DAX measures. You may watch the full video of this tutorial at the bottom of this blog. Using this technique, we would only need to create a simple slicer to convert a currency to another.
Using variables is a great way to make sure that your results add up the way they should at the end of your measures. Variables are such a crucial part of writing and solving formulas inside Power BI and I’m going to show you why. You may watch the full video of this tutorial at