Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 Reporting