Forum Discussion

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

Exclude future dates filter

Hi everyone, so I have this measure that excludes future dates in my filter visual. However, it doesn't include the dates that actually had data. Say I have data from April 1 to 6 and it doesn't show...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    ronaldbalza2023 , Try with min, as in case of date table, max can month end date

    Exclude future dates =
    IF ( Min('Date'[Date] ) <= TODAY(), 1, 0 )

     

    or use date from fact /data table

     

    IF ( Max('Table'[Date] ) <= TODAY(), 1, 0 )

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

ronaldbalza2023 , Try with min, as in case of date table, max can month end date

Exclude future dates =
IF ( Min('Date'[Date] ) <= TODAY(), 1, 0 )

 

or use date from fact /data table

 

IF ( Max('Table'[Date] ) <= TODAY(), 1, 0 )