topic undefinedTest if a day is a weekday but don't used function weekday in DAX Commands and Tips

undefinedTest if a day is a weekday but don't used function weekday

Eric-De — Wed, 27 Mar 2024 09:40:07 GMT

Hello

I need to test if a day is a weekday or not , I used a calandar table and table of usual date . I used the following commands

FirstDayIsOH =
var result = CALCULATE(
COUNTROWS(TableHeuresBureau),
DATESBETWEEN(
TableHeuresBureau[Value],
'Sheet1'[Start],
'Sheet1'[Start]
),
TableHeuresBureau[JourSemaine] >=2 && TableHeuresBureau[JourSemaine] <= 6,
ALL('Sheet1')
)
return
if(ISBLANK(result),false,TRUE)

That running perfectly but I'm not satisfy by this , because it seem not a good code.

If some people have a better code (used table calandar and table date?

I hope I'm clear

Re: undefinedTest if a day is a weekday but don't used function weekday

Anonymous — Thu, 28 Mar 2024 01:22:12 GMT

HI Eric-De,

You can use the following measure formula to check if the first date is workday:

FirstDateIsWorkday = VAR firstDate = MIN ( TableHeuresBureau[From] ) RETURN IF ( WEEKDAY ( firstDate, 2 ) < 6, "Y", "N" )

Regards,

Xiaoxin Sheng

Re: undefinedTest if a day is a weekday but don't used function weekday

Eric-De — Thu, 28 Mar 2024 06:14:06 GMT

Hello Xiaoxin

Thank for this reply, but as I said, I would like to avoid using the weekday function. I have already this inforltion in the table and column TableHeuresBureau[JourSemaine]

Best regards

Re: undefinedTest if a day is a weekday but don't used function weekday

Anonymous — Mon, 01 Apr 2024 07:29:02 GMT

HI Eric-De,

Perhaps you can try to use format function with 'w' optional parameter, it will return the text number of weekday of the current date based on regular weekday format(Sunday to Saturday) You only need to use Value function to convert it back to number.

FORMAT function (DAX) - DAX | Microsoft Learn

FirstDateIsWorkday = VAR firstDate = MIN ( TableHeuresBureau[From] ) RETURN IF ( VALUE ( FORMAT ( firstDate, "w" ) ) < 6, "Y", "N" )

Regards,

Xiaoxin Sheng

Re: undefinedTest if a day is a weekday but don't used function weekday

Eric-De — Tue, 02 Apr 2024 05:16:54 GMT

Hello Xiaoxin

In fact, I need to determine if the day 'Sheet1'[Start] is a officeday or not.

But thank for your help 🙂

Best regards