if date possible switch

Hi If someone can assist please? I would like to say in 1 column the below please? The rdate contains a series of dates in the past and the future. rdate = last order over 2 and a half ...

govindarajan_d

2 years ago

Ok. I wrote the formula for a measure actually.

Please use the following for calculated column:

rdateCalc =
VAR __Difference =
    DATEDIFF ( 'SomeDateTable'[rdate], TODAY (), DAY )
VAR __Result =
    IF (
        __Difference > 913,
        1,
        IF (
            __Difference < 913
                && __Difference > 0,
            3,
            IF ( __Difference < 0 && __Difference > -180, 2, BLANK () )
        )
    )
RETURN
    __Result

govindarajan_d

Super User

2 years ago

Ok. I wrote the formula for a measure actually.

Please use the following for calculated column:

rdateCalc =
VAR __Difference =
    DATEDIFF ( 'SomeDateTable'[rdate], TODAY (), DAY )
VAR __Result =
    IF (
        __Difference > 913,
        1,
        IF (
            __Difference < 913
                && __Difference > 0,
            3,
            IF ( __Difference < 0 && __Difference > -180, 2, BLANK () )
        )
    )
RETURN
    __Result

matts29

Frequent Visitor

2 years ago

Ahh that is fantastic-thank you! I need to learn now what everything is doing 🙂

Forum Discussion

if date possible switch