How to restrict future dates from a date column using DAX

[Anonymous]

I have a date column( Date Week Ending) . As my table has future dates , when i am adding this "Date week ending" to my Slicer, it is displaying Future dates also. But i want to limit this to current week ending date. Only wanted to add filters/Condition to my Dax.

The below is my date column:

Date Week Ending = FORMAT(RIGHT(ConsumerActs[W/E Friday],10),"dd/mm/yyyy").

Kindly Help

Regards,

Tanusah

[v-danhe-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, you could refer to below formula:

Related date = IF([Date]>TODAY(),BLANK(),[Date])

Result:

Regards,

Daniel He