Forum Discussion
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...
johnt75
Super User
Super UserAfter 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.
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.