Cumulative Values Going beyond Current Date

Anonymous — Thu, 12 May 2022 13:16:43 GMT

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

Re: Cumulative Values Going beyond Current Date

johnt75 — Thu, 12 May 2022 14:29:35 GMT

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