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: Crop modeling

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

Challenge: Crop modeling

“

(upbeat music) - [Instructor] Now you're going to have a chance to try out these DAX models and logic on your own as part of the challenge problem. We're going to use the US agricultural numbers for the individual products from the USDA website. I've already queried annual US production of crops from 1980 until 2022 and stored these results, the data itself in the exercise files or the GitHub account. I've also already set up a Power BI Desktop PBIX file containing the data table connections in Power Query and loaded it into the model. We want to use the DAX concepts covered in this course to determine the change in crop volume grown between the years 2015 and 2022. You can then show the results in a table visual with two fields: one for the commodity name, like soy or apples and another field for the change in volume over the same time period.

Contents