Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ELW
Advocate II
Advocate II

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]) but I can't figure out how to filter it for before today.  

 

For example:  

Date
2/28/2021
3/3/2021
3/5/2021
7/22/2021
7/22/2021
12/18/2021
5/27/2022
5/27/2022
6/27/2022
8/14/2022
8/14/2022
8/17/2022
12/23/2022
12/23/2022

 

What I want (distinct and before today):

Result
2/28/2021
3/3/2021
3/5/2021
7/22/2021
12/18/2021
5/27/2022
6/27/2022
8/14/2022
8/17/2022

 

Thanks in advance, this seems like it should be simple and I can't get it to work!  

1 ACCEPTED SOLUTION
daXtreme
Solution Sage
Solution Sage

[Your Table] =
var tooday = TODAY()
return
  FILTER(
    DISTINCT( T[Date] ),
    T[Date] <= tooday
  )

View solution in original post

2 REPLIES 2
daXtreme
Solution Sage
Solution Sage

[Your Table] =
var tooday = TODAY()
return
  FILTER(
    DISTINCT( T[Date] ),
    T[Date] <= tooday
  )

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors