From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Unlock the full course today

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

DAX ruler using FIRSTDATE, LASTDATE, and PARALLELPERIOD DAX functions

DAX ruler using FIRSTDATE, LASTDATE, and PARALLELPERIOD DAX functions - Power BI Tutorial

From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Start my 1-month free trial Buy for my team

DAX ruler using FIRSTDATE, LASTDATE, and PARALLELPERIOD DAX functions

“

- [Instructor] The key for using DAX measures is that we want to filter the data first, then apply the calculation to those filtered rows. Let's think of DAX calculations from a certain point along a ruler. Let's specifically focus on time intelligence calculations at this example. So when we stand at a point along this ruler, let's say our pivot coordinates are a single date along a timeframe. From this point on the ruler, we can change how we're calculating the result at that point in time. One way we can change our filtering is by moving to another point along the ruler. Another way we can change the pivot coordinates for evaluating a DAX measure is by expanding the ruler to include more points than where we're currently standing at. This increases the filter range that we're calculating the results over. We can also combine these actions so we both move to new point and expand the points around that new point, or…

Contents