Please check my report if the DAX is correct. I have completed the steps below in the report:
PBIXhttps://drive.google.com/file/d/1GfXV6GZJWaM1y9v6G9zKOCJ6xsBmV7sc/view?usp=sharing
"
Task 1 (use crop data)
-
Determine the change in crop volume grown for the years 2015 -2021
-
Determine the annualized rate of growth for each commodity between 2015 -2021
-
Show in table visual with 3 columns, the commodity, change in volume, rate of growth
Task 2 (use crop data)
-
Pick one commodity
-
Use the rate of growth to compare projected growth to the actual growth
-
Create a Chart to compare actuals vs projections
Task 3 (use sales data)
-
Create a column chart comparing Actuals vs budget and prior year ( By month)
-
The budget should be cumulative for full year as a trendline
-
Prior year should be column by month (displayed for full year) cumulative
-
Actuals in column displayed as cumulative by months (display months only for months selected)
"