Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm looking for a calculated column on the end of a date table that categorises the last 4 working days (0 to 3)
I've gotten close, but no cigar without writting an endless IF/SWITCH - Any help would be appreciated!
I'm looking to categorize as follows:
Date | Category | Date | Category | |
Friday, January 26, 2024 | 3 | Monday, July 26, 2027 | Other | |
Saturday, January 27, 2024 | 2 | Tuesday, July 27, 2027 | 3 | |
Sunday, January 28, 2024 | 2 | Wednesday, July 28, 2027 | 2 | |
Monday, January 29, 2024 | 2 | Thursday, July 29, 2027 | 1 | |
Tuesday, January 30, 2024 | 1 | Friday, July 30, 2027 | 0 | |
Wednesday, January 31, 2024 | 0 | Saturday, July 31, 2027 | 0 |
What is a working day in your part of the world? What about holidays?
Doing this in Power Query or DAX is an exercise in futility. Use an external reference table that already has that column prefilled.
Hello Ibendlin - Working day is Monday to Friday - Can Ignore Holidays.
I've tried using a standard Is Working Day flag but cannot manage to get it to work.
Doing this in Power Query or DAX is an exercise in futility. Use an external reference table that already has that column prefilled.