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.

Solution: DAX time intelligence modeling

Solution: DAX time intelligence modeling - Power BI Tutorial

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

Start my 1-month free trial Buy for my team

Solution: DAX time intelligence modeling

“

(upbeat tune) - [Instructor] In the Power BI file for US crop data I'm going to first sort the rate of change to see which one is the highest to lowest. I'm going to use pumpkins as the commodity to track over time so we can visually see the rate of growth more clearly. Let's calculate the volume for each year for pumpkins using the calculate function with the commodity equal to pumpkins in the second parameter of the formula. Next let's calculate the total pumpkins for each year between 2015 and 2021 using the if function to reference the range of dates between these two years, the starting and ending year, and then referencing the volume for the pumpkins in the calculate function, and otherwise we'll leave this result as a blank. We'll then calculate the rate of change specifically for pumpkins. Let's add this number so far to a line chart, or rather let's start as a table visual in this same space. In order to…

Contents