Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Helper V
2 years ago
Solved

DAX Quality Check

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)

"

DAX
  • lbendlin's avatar
    lbendlin
    2 years ago

    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.

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.