Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have a dataset of construction schedule (more than 3400 tasks), which have all the information task wise (start/end dates, total resources/workforce numbers allocated for that task, etc.). My project have saturday & sunday as holiday.
I've calculated average workforce per day using DAX below:
Solved! Go to Solution.
You can approach this two ways. In another column, add this formula:
Date.DayOfWeek([Date], Day.Saturday)
That will mark Saturday as 0, Sunday as 1, and Mon-Fri as 2-6. Now, either filter out days < 2, or add "<2" to the end, that will return True for weekends and False for weekdays.
Now filter that out, or using DAX, you can count the days excluding the TRUE values for weekends.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThis worked. Thanks so much for your input!!
Great @vikas_patel81 - glad I was able to assist!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou can approach this two ways. In another column, add this formula:
Date.DayOfWeek([Date], Day.Saturday)
That will mark Saturday as 0, Sunday as 1, and Mon-Fri as 2-6. Now, either filter out days < 2, or add "<2" to the end, that will return True for weekends and False for weekdays.
Now filter that out, or using DAX, you can count the days excluding the TRUE values for weekends.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCheck out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
70 | |
63 | |
40 | |
28 | |
16 |