How to make a measure: Measure + Value of measure last month

[Niels_T]

Hello,

I tried to make the following measure:

Measure =

IF( EOMONTH(MAX('Calendar'[Date]),0) < EOMONTH(TODAY(),0) ,

[Stock Niveau]) + CALCULATE([Stock Niveau], PREVIOUSMONTH('Calendar'[Date]))

The result that I expected was if the month is above the current month, then take the original value of stock niveau of that month + the value of the stock niveau of the previous month.

Someone knows how to make this measure?

[v-chenwuz-msft]

Hi @Niels_T ,

Maybe you can try this:

Measure =

IF( EOMONTH(MAX('Calendar'[Date]),0) < EOMONTH(TODAY(),0) ,

[Stock Niveau]) + CALCULATE([Stock Niveau], all('Calendar'[Date]),(PREVIOUSMONTH('Calendar'[Date]))

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Niels_T , try like

IF( EOMONTH(MAX('Calendar'[Date]),0) <= EOMONTH(TODAY(),0) , [Stock Niveau] , [Stock Niveau] + CALCULATE([Stock Niveau], PREVIOUSMONTH('Calendar'[Date])))

[Niels_T]

Unfortunately the measure didn't work.

It should start accumulating like a YTD-function, however it didn't and it gave me a number in the minus instead.