Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative Values Going beyond Current Date

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's avatar
    johnt75
    4 years ago

    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

1 Reply

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    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