Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |