Hi @ajitsahoo8338 ,
I think it is working fine.
From 20th AUgust to 27th August, there are 8 days. Excluding saturday and sunday that comes in those days, it is 6 working days.
One more example is given below for the same case
Between 16th August and 27th August, there are 12 days with 2 saturdays and 2 sundays. The Working days in this case is shown as 8 excluding the 4 weekend days
Regards,
Hi @ajitsahoo8338 ,
Create a new column to identify the weekday using the below DAX
Weekday = WEEKDAY('Table'[Date], 1)Then Create a measure as shown below
Workingdays = CALCULATE(DISTINCTCOUNT('Table'[Date]), AND('Table'[Weekday] <> 1, 'Table'[Weekday] <> 7))
Ajit has 23 days, but workingdays measure returns 22 exluding the saturday in the list
Regards,
Hello @Thejeswar Thank you for your response. The measure is working fine but If filter any date then working days is not showing correctly Like Below. Total should show 12
Hi @ajitsahoo8338 ,
I think it is working fine.
From 20th AUgust to 27th August, there are 8 days. Excluding saturday and sunday that comes in those days, it is 6 working days.
One more example is given below for the same case
Between 16th August and 27th August, there are 12 days with 2 saturdays and 2 sundays. The Working days in this case is shown as 8 excluding the 4 weekend days
Regards,
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
