Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Aggregated Running total for YoY/Change

Hi Everyone,   I have an Install base (customer count) measure which distinctcounts the number of customer IDs as follows:   I also have a similiar measure for the same period last year: ...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    When you do your "Same Period LY measure, can you do it like this:

    SPLY Install Base LABRA = CALCULATE([Install Base LABRA], SAMEPERIODLASTYEAR(Dates[Date]))
    Then subtract your initial measure from this. I'll call it VAR Install Base LABRA
     
    To get cumlative total for the VAR Install Base LABRA
     
    = CALCULATE([VAR Install Base LABRA], FILTER(ALLSELECTED(Dates), 
     Dates[Date] <= MAX(Dates[Date])))

    Normally this should work. Can you give it a try? Thanks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Whitewater100 , i'll try changing to my calendar table (i used the detail table date instead) and will update. 

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hello:

Great. I hope that works for you and if it does can you mark as solution? Thanks...