cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Dax formula for number of weekends (Friday and Saturday) in month without creating date table

Hello!

Hoping someone can help me out in this community.

I would like to create a new column in a table that calculates the number of weekends (Fridays and Saturdays only) in a month. I have the following columns in my table:

Year
Month
Month Number
Date

I was able to get the number of days in the month through this formula:

``````DaysinMonth = DAY(
IF(
) - 1
)``````

How can I modify this formula to get number of weekend days (friday and saturday) in a month? I want to do this by adding a new column not making a date table with measure.

Thank you!!

1 ACCEPTED SOLUTION
Super User

Countrows(filter(calendar(eomonth([Date],-1)+1, eomonth([Date], 0) ), weekday([Date]) in {6,7} ))

Another way is

Datediff((eomonth([Date],-1)+1, eomonth([Date], 0) , Day) +1 - networkdays(eomonth([Date],-1)+1, eomonth([Date], 0), 7 )

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c

2 REPLIES 2
Super User

Countrows(filter(calendar(eomonth([Date],-1)+1, eomonth([Date], 0) ), weekday([Date]) in {6,7} ))

Another way is

Datediff((eomonth([Date],-1)+1, eomonth([Date], 0) , Day) +1 - networkdays(eomonth([Date],-1)+1, eomonth([Date], 0), 7 )

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c

Frequent Visitor

This is awesome. Thank you so much!!!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors