Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculating a running total from a measure

Hi All,   I am trying to create a running total from a measure using this formula:  runningtotal = SUMX(FILTER(ALLSELECTED('Calendar'[MonthYear]), 'Calendar'[MonthYear] <= MAX('Calendar'[MonthYea...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    To update the measure should work.

     

    runningtotal = SUMX(FILTER(ALLSELECTED('Calendar'),'Calendar'[Date]<=MAX('Calendar'[Date])),'Table1'[fc_FB_Change])

     

    Regards,

    Frank

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

To update the measure should work.

 

runningtotal = SUMX(FILTER(ALLSELECTED('Calendar'),'Calendar'[Date]<=MAX('Calendar'[Date])),'Table1'[fc_FB_Change])

 

Regards,

Frank