DAX Quality Check

Yrstruly2021 — Thu, 27 Jun 2024 15:01:06 GMT

Please check my report if the DAX is correct. I have completed the steps below in the report:

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)

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)

Re: DAX Quality Check

lbendlin — Thu, 27 Jun 2024 23:16:52 GMT

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.