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.

Challenge: Rate of change by commodity

Challenge: 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

Challenge: Rate of change by commodity

“

(lively music) - [Instructor] For this chapter's challenge, we're going to continue to use the USDA agricultural data we saw in the previous chapter in our Power BI model. Your objective for this chapter's challenge is to determine the annualized rate of growth for each of the commodities like soy or corn, for example, between 2015 and 2021. Much like the accrued value calculation earlier in this chapter, we already have some inputs for our model but we need to solve for part of the equation that we don't know yet, which in this case is r the rate. I find it helpful to get out a pen and paper to solve for the unknown interest rate variable r as an equation to then set up DAX measures based on the rewritten formula.

Contents