Forum Discussion
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...
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.
