Forum Discussion

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi KeepCalm007,

 

Sorry for the late response. Based on my test, the formula below should work in your scenario. :smileyhappy:

Measure = 
VAR currentMonth =
    MONTH ( TODAY () )
VAR monthNo =
    MONTH ( MAX ( 'In-Home'[Closed].[Date] ) )
RETURN
    IF ( monthNo < currentMonth, [Cumulative To End of Year] )

 

Regards

KeepCalm007's avatar
KeepCalm007
Helper I
8 years ago

Greetings v-ljerr-msft, your formula was working ..

.. but stopped working after  I downloaded the latest update of power bi desktop :(

 

I haven't made any changes to the measures, so am unsure why things are behaving differently.

 

 

Is it an issue with the other measures? But I can't think what is wrong with them if they were working before :/

 

Cumulative To End of Year =
CALCULATE (
[Exits],
FILTER ( ALLEXCEPT ( 'Closed Cases', 'Closed Cases'[Service Type], 'Closed Cases'[Service], 'Closed Cases'[Outcome]),'Closed Cases'[Closed].[Date] <= MAX ( 'Closed Cases'[Closed].[Date])))

 

 

Exits = COUNTROWS('Closed Cases')

 

Again, I appreciate any advice or pointers! I didn't think I would have such difficulty.

update: file