Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Month value from Runing total

Hello Community, How can I extract month value if I have runing total to each month in year and  ID? I know how to do it in Excel:    =if( mid([PERIOD];6;2)=1;[@RUNING_TOTAL]; SUMPRODUCT([RU...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

helassal's avatar
helassal
Resolver II
6 years ago

Anonymous ,

 

You need first to get the running sum value for previous month and then subtract "previous month running sum" from "current month running sum" to get each month's value.

 

Running Sum of Previous Month:

Prev.Month Running Sum Value = CALCULATE( max('Table'[RUNNING TOTAL]), PREVIOUSMONTH('Table'[PERIOD]))

 

Current Month Value:

Current Month Value = CALCULATE(max('Table'[RUNNING TOTAL])) - [Prev.Month Running Sum Value]

 

 

Here is the example file I was using: Sample File 

 

Best Regards,

Haitham