DAX Quality Check

[Yrstruly2021]

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)

1. Determine the change in crop volume grown for the years 2015 -2021
2. Determine the annualized rate of growth for each commodity between 2015 -2021
3. Show in table visual with 3 columns, the commodity, change in volume, rate of growth

Task 2 (use crop data)

1. Pick one commodity
2. Use the rate of growth to compare projected growth to the actual growth
3. Create a Chart to compare actuals vs projections

Task 3 (use sales data)

1. Create a column chart comparing Actuals vs budget and prior year ( By month)
2. The budget should be cumulative for full year as a trendline
3. Prior year should be column by month (displayed for full year) cumulative
4. Actuals in column displayed as cumulative by months (display months only for months selected)

"

[lbendlin · Accepted solution]

1.2. Notice how the Total is 100%.  That isn't correct.  You also used %CT - why?

2.2 Debatable chart type. There is no dependency between annual volumes. Consider using a column chart.

3.3. They want monthly columns for the entire prior year.