Working Days Table

[Stuartm1983]

Hello,

I'm hoping that somebody knows a straightforward way of achieving to build a table containing working days only using DAX?

Thanks

[v-alq-msft]

Hi, @Stuartm1983 

 'IsWorkingDay' is computed by simply checking if the date is a Saturday or Sunday. 

'Date'[IsWorkingDay] = NOT WEEKDAY( 'Date'[Date] ) IN { 1,7 }

I'd like to suggest you refer to the following links.

https://www.sqlbi.com/articles/counting-working-days-in-dax/

https://community.powerbi.com/t5/Desktop/Networkdays-DAX-function/td-p/38044

https://community.powerbi.com/t5/Desktop/DATEDIFF-Working-Days/td-p/130662

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Stuartm1983]

Thanks.

Ive pretty much got what I need. Thank you.

Does Anyone know how to calculate if the date is an Eater Monday or Good Friday in Dax per chance?

I'm trying to avoid using a holiday input table.

[amitchandak · Accepted solution]

Refer if this can help

https://community.powerbi.com/t5/Desktop/WORKING-DAYS-HOLIDAYS-IN-MY-POWERBI-DATA-MODEL/m-p/889564

https://community.powerbi.com/t5/Desktop/Number-of-working-days/m-p/22842