topic Re: DAX End Of Month Working Day Categorization in DAX Commands and Tips

DAX End Of Month Working Day Categorization

Anonymous — Fri, 26 Jan 2024 22:23:32 GMT

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

Re: DAX End Of Month Working Day Categorization

lbendlin — Sat, 27 Jan 2024 02:16:26 GMT

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.

Re: DAX End Of Month Working Day Categorization

Anonymous — Sat, 27 Jan 2024 05:19:10 GMT

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.

Re: DAX End Of Month Working Day Categorization

lbendlin — Sun, 28 Jan 2024 04:02:34 GMT

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