Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Icon for Continued Contributor rankContinued Contributor
4 years ago
Solved

Hide future dates

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 = CALCULA...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    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())

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
ronaldbalza2023
Icon for Continued Contributor rankContinued Contributor
4 years ago

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