Add a column in PBI that indicates workday of the month
Budget: €8 – €30 EUR
1. I have a simple dynamic table (Date-Reference-Table) with calendar days.
2. I have another table (Holidays) with holidays: date, name, type.
3. I want to add a column in my Date-Reference-Table that dynamicly indicates WD of the month, under the following conditions: Weekdays (Monday-Friday) counts as workdays, unless it's a National or Local Holiday (holiday-type). Weekend-days (Saturday-Sunday) should equal the latest workday.
2. I have another table (Holidays) with holidays: date, name, type.
3. I want to add a column in my Date-Reference-Table that dynamicly indicates WD of the month, under the following conditions: Weekdays (Monday-Friday) counts as workdays, unless it's a National or Local Holiday (holiday-type). Weekend-days (Saturday-Sunday) should equal the latest workday.