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

Hi Anonymous ,

 

See if this helps.

 

https://community.powerbi.com/t5/Desktop/Public-Holiday-Script/td-p/178341

https://community.powerbi.com/t5/Power-Query/Excluding-School-holidays-from-date-count/m-p/962281

https://community.powerbi.com/t5/Desktop/Dynamic-Holiday-Calendar/m-p/866747

 

You basically need to create a Holiday Table and a Column for your Company Holiday and comapare the two Column.

 

The above link compares Holidays with Weekend, you would need to compare your Company Holidays with all the Major Holidays 

 

Hope this helps.

 

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!