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

[Eric-De]

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

[Eric-De]

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

[v-shex-msft]

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

[Eric-De · Accepted solution]

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

[v-shex-msft]

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