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 D...
  • 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

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