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.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
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.