From the course: Power BI Data Dashboards

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Building and using DAX formulas

Building and using DAX formulas - Power BI Tutorial

From the course: Power BI Data Dashboards

Start my 1-month free trial Buy for my team

Building and using DAX formulas

“

- [Instructor] Using data analysis expressions, or DAX for short in Power BI is really important, but the otherwise simple syntax belies logic that's a bit trickier to understand. If you have a background in programming, you'll likely know firsthand the importance of testing results step-by-step along the way to make sure they work. I think about the logic behind DAX measures in two steps. First we filter the data table over which we want to perform the calculation. We then calculate the aggregated result over this filter data table. I already set up a calculations table as a measure group in the model, it contains a DAX measure for the population. We see it's a measure because there's a calculator icon next to it. Your measure icon might look different but the measure will still work in the same way. The calculate function is the backbone for creating DAX measures. We can see how it wraps around the sum of the…

Contents