Forum Discussion
Relative date
Good day
I am new to power BI and need some help with relative date,
I have a a dash board with a relative date filter, i know how to show data for last month or last 3 days etc, however i want all the visuals to show a specific single day (3 days ago) my data set has the last 2 days data in it which i don't want shown in the visuals
Thanks in advance
Hi Taariq ,
Try below formula:
M = VAR day1 = DAY ( TODAY () ) - 1 VAR day2 = DAY ( TODAY () ) - 2 RETURN ( IF ( DAY ( MAX ( 'Table'[Date] ) ) = day1, 1, IF ( DAY ( MAX ( 'Table'[Date] ) ) = day2, 1, IF ( ( DAY ( MAX ( 'Table'[Date] ) ) = DAY ( TODAY () ) ), 1, 0 ) ) ) )If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Taariq ,
Try below formula:
M = VAR day1 = DAY ( TODAY () ) - 1 VAR day2 = DAY ( TODAY () ) - 2 RETURN ( IF ( DAY ( MAX ( 'Table'[Date] ) ) = day1, 1, IF ( DAY ( MAX ( 'Table'[Date] ) ) = day2, 1, IF ( ( DAY ( MAX ( 'Table'[Date] ) ) = DAY ( TODAY () ) ), 1, 0 ) ) ) )If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.