Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table that has all the working days identifed for a project between the start and end date. I need a measure to add up all the working days for each project from Start date to today, Thanks in advance
Solved! Go to Solution.
Hi @ctedesco3307 ,
I suggest you to try this code to create a measure.
Measure =
VAR _MINDATE = MIN(MAX('Table'[End Date]),TODAY())
VAR _COUNT = CALCULATE(SUM('Table'[Working Day]),FILTER('Table','Table'[MSSContractDay]<=_MINDATE))+0
RETURN
_COUNT
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A new column
networkdays([Start Date], Today(),1)
https://amitchandak.medium.com/power-bi-dax-function-networkdays-5c8e4aca38c
@amitchandak thank you but the function needs to sum the workingday column in the table if workingday = 1 -- not just omit saturday and sunday - we have company holidays also
Hi @ctedesco3307 ,
I suggest you to try this code to create a measure.
Measure =
VAR _MINDATE = MIN(MAX('Table'[End Date]),TODAY())
VAR _COUNT = CALCULATE(SUM('Table'[Working Day]),FILTER('Table','Table'[MSSContractDay]<=_MINDATE))+0
RETURN
_COUNT
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi Rico,
am using your DAX statement like this:
hi Rico,
forget about my question, found the issue and solved it.
The measure is working!
thnx!!!!
@ctedesco3307 , Please refer blog I shared complete information on how to use the holiday calendar
https://amitchandak.medium.com/power-bi-dax-function-networkdays-5c8e4aca38c
User | Count |
---|---|
66 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |