Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extracting and comparing ranges

Hello, I've spent a ton of hours trying to find an answer to this problem, but there doesn't seem to be any as far as I can tell.   My goal is to create a column that identifies if the date is a wo...
dates
range of text
variables
  • lbendlin's avatar
    lbendlin
    6 years ago

    what you are looking for is the "IN"  keyword. Note it needs curly bracket, unlike in SQL.

     

    WorkingDay = IF('DateTable'[Holiday] IN {"Memorial Day", "Thanksgiving Day", etc}, 0, 1)

     

    your other question is difficult to answer without seeing the data model.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks everyone for all the resources!

 

lbendlin I did think about the IN operator, but wasn't able to get it to work. I did find a way to get around it.

 

As for the first issue, I settled on a solution that required me to create a calculated column to pull in the day after Thanksgiving on the holiday table. Then it was easy to use that column to identify the day after Thanksgiving on the date table.

DayAfterThanksgiving Date = IF( 'Holiday'[Holiday] = "Thanksgiving Day", 'Holiday'[Date]+1, Blank() )