Forum Discussion

Sal29's avatar
Sal29
Frequent Visitor
3 years ago

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...
General Comment
Need Help
rubayatyasmin's avatar
rubayatyasmin
Community Champion
3 years ago

HI, Sal29 

 

I tried in a different and easy way. here is the demo file. File will be automatically deleted after download. I just copied your data. You might need to adjust the query steps with your original data. 

 

Here is a summery of what I did. 

 

1. Created name of the day column for both order date and packed date.  "Add Column" > "Date" > "Day" > "Name of Day." Do this for both Order Created Date and Order Packed Date.

 

2. Extracted hour from the add column> Date> time>hour. for both order and packed date. 

 

3. Finally, a custom column is created, resulting value is SLA-fail or Pass. 

 

 

 

Sal29's avatar
Sal29
Frequent Visitor
3 years ago

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

  

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    3 years ago

    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.