Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

12 Month Moving Average on Calculated Field

Hey All - I'm trying o write DAX to solve for a 12 month moing average on a calculated percentage.  The percentage I'm interesting in averaging is a Win Rate (Amount Won / Amount Closed).   Amount ...
Parkavi's avatar
Parkavi
Frequent Visitor
6 years ago

AnonymousPlease try using a quick measure "Rolling Average" for the base measure "Win rate".

You can use date field from the date table instead from your fact.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thanks Parkavi , so that seems so work when displayed with the Date hierarchy from the DateTable, but when using Fiscal Date applications included within the date field, it appears to fail and calculate on blanks.  Any idea why that may be?

     

    Left chart & table are using fiscal year/quarter along with month from the date hierarchy.  Right is using year/quarter/month from date hierarchy.  Note: year and quarter won't line up between fiscal and calendar.