Forum Discussion

ELW's avatar
ELW
Icon for Advocate II rankAdvocate II
4 years ago
Solved

DAX Distinct dates, filtered before today

I have a table with dates in it.  I want to create a new table from a unique list of dates, but have it filtered for dates before today.  I am able to get the new table with = DISTINCT('Date'[Date]) ...
Date
DAX
Distinct
Filter
  • daXtreme's avatar
    daXtreme
    4 years ago
    [Your Table] =
var tooday = TODAY()
return
  FILTER(
    DISTINCT( T[Date] ),
    T[Date] <= tooday
  )
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago
[Your Table] =
var tooday = TODAY()
return
  FILTER(
    DISTINCT( T[Date] ),
    T[Date] <= tooday
  )
  • ELW's avatar
    ELW
    Icon for Advocate II rankAdvocate II
    4 years ago

    Beautiful, thank you!!  I appreciate your fast response, you're living up to your username!  🙂