Yvain
Yvain
Programming language:Whatever
2021-08-25 12:45:46
0
Q:

power BI count absent days no weekend

colmde
colmde
Code: Whatever
2021-08-19 13:21:55 
IsWorkingDay = IF (NOT(DimTable[WeekName] = "Saturday" || (DimTable[WeekName] = "Sunday")) && COUNTX(RELATEDTABLE(Holidays);1) < 1; 1; 0)

/*
IsWorkingDay is in DimTable. 
First part of formula is saying take every day from Monday to Friday (not Saturday or Sunday),
and second part is going into Holidays Table where I have list and dates of holidays. 
Everything is conducted with IF function. 
The result is 1 for working days and 0 for holiday or weekend.
*/
0

Tags

Related

New to Communities?

Join the community