Hide future dates

[ronaldbalza2023]

Hi everyone, how to hide the future dates for my cumulative measure? I wanted to hide the future date base on the current filter.

Here's the measure:

Total Sales by Department YTD = 
CALCULATE (
    [Invoiced amount time + total costs],
    FILTER (
        ALL ( 'Date' ),
        'Date'[Financial Year] = MAX ( 'Date'[Financial Year] )
            && 'Date'[Date] <= MAX ( 'Date'[Date] )
    ), 'Date'[Date] <= TODAY() 
)

[amitchandak · Accepted solution]

@ronaldbalza2023 , Try

Total Sales by Department YTD =
CALCULATE (
[Invoiced amount time + total costs],
FILTER (
ALL ( 'Date' ),
'Date'[Financial Year] = MAX ( 'Date'[Financial Year] )
&& 'Date'[Date] <= MAX ( 'Date'[Date] ) && 'Date'[Date] <= TODAY()
)
)

or

Total Sales by Department YTD =
if( max('Date'[Date] <= TODAY()), CALCULATE (
[Invoiced amount time + total costs],
FILTER (
ALL ( 'Date' ),
'Date'[Financial Year] = MAX ( 'Date'[Financial Year] )
&& 'Date'[Date] <= MAX ( 'Date'[Date] )
)
), blank())

[ronaldbalza2023]

Hi @amitchandak , thanks for taking the time on this. It doesn't do anything unfortunately.