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.
Hi Everyone,
Im self teachign myself to use powr BI and have been able to do several things now, but I am not able to find a formula I need.
I have a column which shows the month and the year, I need a formaul that will read that month/year and come back with how many days in that given month were "workign days"
Thats the column I have I need for it to show next to it for example "22" (If there were 22 working days on February, and "25" if there were 25 working dasy on January an
Solved! Go to Solution.
Hi, @LCL
You can try the following methods. Create a new date table.
Table:
Date = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))
Column:
Weekday = WEEKDAY([Date],2)
Month = FORMAT([Date],"mmmm")
days =
CALCULATE (
COUNT ( 'Date'[Date] ),
FILTER ( 'Date', [Weekday] <= 5 && [Month] = EARLIER ( 'Date'[Month] ) )
)
working days = [Month]&[days]
If your form is similar to this. You can join two tables with Month.
Is this the result you were hoping for?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @LCL
You can try the following methods. Create a new date table.
Table:
Date = CALENDAR(DATE(2022,1,1),DATE(2022,12,31))
Column:
Weekday = WEEKDAY([Date],2)
Month = FORMAT([Date],"mmmm")
days =
CALCULATE (
COUNT ( 'Date'[Date] ),
FILTER ( 'Date', [Weekday] <= 5 && [Month] = EARLIER ( 'Date'[Month] ) )
)
working days = [Month]&[days]
If your form is similar to this. You can join two tables with Month.
Is this the result you were hoping for?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@LCL , There new function provided by power bi networkdays
https://docs.microsoft.com/en-us/dax/networkdays-dax
do you have month start and end date in you table
If you have date then
Start Date of month = eomonth([Date],-1)+1
end Date of month = eomonth([Date], 0)
Old method
How to calculate Business Days/ Workdays, with or without date table: https://youtu.be/Qv4wT8_P-AA
Thanks but thats the problem, I dont have the dates on the table only the month 😞
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
50 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |