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

[goodhvnting]

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(
        MONTH('Your Table'[Date Field]) = 12,
        DATE(YEAR('Your Table'[Date Field]) + 1,1,1),
        DATE(YEAR('Your Table'[Date Field]),  MONTH('Your Table'[Date Field]) + 1, 1)
    ) - 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!!

[amitchandak · Accepted solution]

@goodhvnting ,

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

[goodhvnting]

This is awesome. Thank you so much!!!