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",
    ""
)
jgeddes's avatar
jgeddes
Super User
3 years ago

You can try something like...

Holiday = 
var _goodFriday =
LOOKUPVALUE('Good Friday Years'[Good Friday], 'Good Friday Years'[Year], dimDate[Date].[Year], 'Good Friday Years'[Good Friday], dimDate[Date])
return
IF(
    ISBLANK(_goodFriday),
    "",
    "Good Friday"
)