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: Rate of change by commodity

Solution: Rate of change by commodity - 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: Rate of change by commodity

“

(upbeat music) - [Instructor] To calculate the annualized rate of return, we want to solve for the rate r in the accumulated value formula given that we know the future value in the year 2021, the current value, we'll say in year 2015, and the length of time over which we're doing these calculations. If we solve for r, we see it equals the quantity of the 2021 numbers divided by the 2015 numbers. Then, raising this factor to 1 divided by the total duration between the measurement periods, which equals 1 divided by 6. We'll then subtract 1 to get a rate instead of a rate factor, which is greater than 1. In Power BI Desktop, let's pick up where we left off for the modeling. We're going to use the DAX measure formula to calculate the annualized rate of return. We'll first create a new measure called the Rate of change. For the calculation itself, we're going to work from the inside going out. We'll start by using the…

Contents