Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am generating a dashboard in which I would like to calculate a SLA due date from a received date. The due date is based on 2 working days (that means I would like to exclude weekends and public holidays).
Any tips?
@cobalt wrote:
I am generating a dashboard in which I would like to calculate a SLA due date from a received date. The due date is based on 2 working days (that means I would like to exclude weekends and public holidays).
Any tips?
You may need a specific calendar table which has specific columns like isWeekend and is holidays and always use this calendar table to calculated the due date.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |