Forum Discussion

rhl94's avatar
rhl94
Advocate III
6 years ago
Solved

Optimizing 12m rolling average

Hi I'm looking to create a measure with 12 month rolling average. I've tried the quick measure "rolling average" and it works fine - except that I can't use any filter on it, otherwise it wont show ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    rhl94 

     

    Remove the logical test for IF in the above formula or drag fields from Date Hierarchy to Slicers.

rhl94's avatar
rhl94
Advocate III
6 years ago

My calendar table is generated using CALENDARAUTO().

 

When marking it as a date table, I can no longer use the date column to generate the quick measure, as it is no longer a hierarchy

 

amitchandak's avatar
amitchandak
Super User
6 years ago

Try the same without making it as date table. But use the calendar date column in formula

  • rhl94's avatar
    rhl94
    Advocate III
    6 years ago
    It gives me the hierarchy back when removing mark as date table and allows me to create a quick measure using the date, however the visual is just blank. There is a relation between date from the two tables