DAX End Of Month Working Day Categorization

[onionnoodle]

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

[lbendlin]

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.

[onionnoodle]

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.

[lbendlin]

Doing this in Power Query or DAX is an exercise in futility.  Use an external reference table that already has that column prefilled.