Forum Discussion
ELW
Advocate II
Advocate IIDAX 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!
[Your Table] = var tooday = TODAY() return FILTER( DISTINCT( T[Date] ), T[Date] <= tooday )
