How to Exclude All sundays and 2nd or 4th Saturdays for getting total working days for every month

[jay_patel]

Hello Community

Here I am looking for dax which can exclude all sunday's and only 2nd & 4th satuday, In the mentioned attachment I added a customer column like (if(date(date)="Saturday"|| "Sunday",0,1) but obviously it excludes every saturday and Sunday.

Thanks in advance

[amitchandak · Accepted solution]

@jay_patel , Try new columns like these in you date table

min week start of month = minx(filter('Date',[Month Year] =earlier([Month Year])),[Week Start date])
week of month = datediff([min week start of month],[date],Week)+1
or
week of month = quotient(datediff([min week start of month],[date],day),7)+1

work day = if(WEEKDAY([Date],2)=7 ||  [week of month] in {2,4}, 0,1)