Relative date

[Taariq]

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

[v-henryk-mstf · Accepted solution]

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.