Filter month year column to exclude future dates from today

[Anonymous]

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

[Fowmy · Accepted solution]

@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 🙂

YouTube  LinkedIn