Forum Discussion

Taariq's avatar
Taariq
New Member
3 years ago
Solved

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 ...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    3 years ago

    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.

     

     

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

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.