Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX formula help

I have some data like this (here only shows the first 20 rows):  This is raw data about each project year, each state, region, device has multiple events, and the value for each event is "Count" colu...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    For Question1, try this rolling average measure

     

    =if(ISBLANK(MIN('Calendar'[Date])),BLANK(),divide('SAMPLE DATA'[Rolling12MonTotal], 12))

     

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi  Ashish_Mathur, thank you! It works for my question 1.

Any suggestion for question 2? Thanks!

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

I believe the answer is in my file to get the average of the previous 12 months

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    LivioLanzo, I am sorry I checked your file a couple of times and the number is not right.

     

    BTW I already solved my question 2. Thank you very much for both your input. LivioLanzo Ashish_Mathur