Forum Discussion
How to restrict future dates from a date column using DAX
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
Hi Anonymous ,
Based on my test, you could refer to below formula:
Related date = IF([Date]>TODAY(),BLANK(),[Date])
Result:
Regards,
Daniel He
1 Reply
Hi Anonymous ,
Based on my test, you could refer to below formula:
Related date = IF([Date]>TODAY(),BLANK(),[Date])
Result:
Regards,
Daniel He