Cumulative Values Going beyond Current Date

[Anonymous]

Hello,

Looking for some help on the following Dax Formula 

Im looking for the "Cumulative Actuals to date" values to stop at 30-April-22 and not repeat to the end of the calander

The Dax formula I used is as follows:

Cumulative Actuals to Date = SUMX(FILTER(ALLSELECTED(Calender[Date]),Calender[Date]<=MAX(Calender[Date])),[Total of Craft and Staff Cost])

I know it has to do with the <=Max Calander date but cant wrap my head around it.... 

Any help would be appreciated

Thanks

[johnt75 · Accepted solution]

Add a new column to your date table like

Current month or before = 'Date'[Date] <= EOMONTH(TODAY(),0)

then wrap the code for your measure inside

IF( SELECTEDVALUE( 'Date'[Current month or before], existing code here )

that will return blank for future dates