Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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)
@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)
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |