Forum Discussion
Power Query Multiple conditions - SLAs
Hi, I am faced with a Power Query problem, and I hope someone can support me, here is a link to a sample file of orders and Public Holiday tables from our database connected to a Power Bi Report Pow...
Hi, thanks for your efforts so far, much appreciated.
However, I checked the file you shared with me and the summary of what you did (above)
Unfortunately, the logic in the custom column in your file seems to "SLA-Fail" all orders.
Also I don't seem to see any consideration for Public Holidays.
Thanks
Hey, you do need to have a separate for public holidays. Then the solution will work. The solution is done assuming you have a separate table for holidays.
need to adjust with the solution I gave you. The solution is an example how you can accomplish your goal.