Forum Discussion
Filter month year column to exclude future dates from today
I have a dates key table that runs from Jan 2018 - Jan 2021.
I have a month year column (Text Format):
Month Year = FORMAT('DimDate'[DateS],"MMM YYYY")
However it pulls in all dates in the dates key range:
Is there a way to exclude future dates from:
FORMAT('DimDate'[DateS],"MMM YYYY"),<=TODAY()
Thanks in advance
Anonymous
Add the following column to your date table
On or Before Today = 'DimDate'[DateS] <= EOMONTH(TODAY(),0)Drag and drop the new column to Filter Pane and set it to TRUE
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
1 Reply
- Fowmy
Super User
Anonymous
Add the following column to your date table
On or Before Today = 'DimDate'[DateS] <= EOMONTH(TODAY(),0)Drag and drop the new column to Filter Pane and set it to TRUE
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂