Forum Discussion

Nimesh2kotadia's avatar
Nimesh2kotadia
Regular Visitor
3 years ago

Rolling average for categories.

I have data in form of three columns (Date, Incidents and Department). I want to calculate a rolling average measure for a chart which has departments in rows, incident sum for each month and finally...
Nimesh2kotadia's avatar
Nimesh2kotadia
Regular Visitor
3 years ago

 It was all coming from a single table. But i can create a date table. How to proceed after creating the date table? 

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

After you've got the date table link that to your fact table and change the definitions of any measures to use the date table instead of the fact table. Also change the visuals to use columns from the date table. It should just work then.

  • Nimesh2kotadia's avatar
    Nimesh2kotadia
    Regular Visitor
    3 years ago

    As you suggested, i used a separate date table and made changes to the formula. It is still giving the same result. Why is it so hard to do simple things in DAX? As shown in below picture, i want to see last three months incidents department wise and 6 month moving average. Instead of total column i want to see RA6M. Can you please help me understand the solution? 

    I created some dummy data in excel like below.