Forum Discussion

Rocky_Brown's avatar
Rocky_Brown
Helper I
3 years ago
Solved

Switch Comparing 2 dates

I have 2 date tables both with unique Dates. 1. Is a Table that displays Year and Good Friday Date      Year             Good Friday      2021            04/02/2021      2022            04/15/202...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    Rocky_Brown 

    Try someting like this for the column.

    Holiday =
SWITCH (
    TRUE (),
    NOT ISBLANK (
        LOOKUPVALUE (
            'Good Friday Years'[Good Friday],
            'Good Friday Years'[Good Friday], Dates[Date]
        )
    ), "Good Friday",
    ""
)
jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

Rocky_Brown 

Try someting like this for the column.

Holiday =
SWITCH (
    TRUE (),
    NOT ISBLANK (
        LOOKUPVALUE (
            'Good Friday Years'[Good Friday],
            'Good Friday Years'[Good Friday], Dates[Date]
        )
    ), "Good Friday",
    ""
)