Forum Discussion
Helper VTime Difference and Networkingdays Question
Hi Walt1010 ,
Thanks for reaching out to the Microsoft fabric community forum.
Using a manual filter on the Date table is generally a better approach than relying on NETWORKDAYS.It works more smoothly with YTD calculations :
Functions like TOTALYTD and PREVIOUSYEAR give more accurate results when they're based on a well-structured Date table.Filtering a small Date table is much faster than calculating working days row by row in a large fact table.
If your weekend or holiday rules change, you can just update the Date table instead of rewriting multiple measures.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team
Impactful IndividualHello,
You can consider the following DAX formulas:
Working Days Difference =
Working Days Difference =
CALCULATE( COUNTROWS(DateTable),FILTER(DateTable,DateTable[Day]<>"Saturday",DateTable[Day]<>"Sunday"))
Alternatively, if you have a column that lists any non-working days, like holidays, you can add that to the filter too
Current YTD Working Days =
Current YTD Working Days = TOTALYTD([Total_Working_Days],DateTable[Date],"1/1")
Previous YTD Working Days =
Previous YTD Working Days =
CALCULATE([Total_Working_Days],DATESYTD(DATEADD(DateTable[Date],-1,YEAR),"1/1"))
Helper VThank you for your answer. Why would it be better to avoid using a function like NETWORKINGDAYS and rather use a manual filter?
v-menakakotaCommunity Support
Hi Walt1010 ,
Thanks for reaching out to the Microsoft fabric community forum.
Using a manual filter on the Date table is generally a better approach than relying on NETWORKDAYS.It works more smoothly with YTD calculations :
Functions like TOTALYTD and PREVIOUSYEAR give more accurate results when they're based on a well-structured Date table.Filtering a small Date table is much faster than calculating working days row by row in a large fact table.
If your weekend or holiday rules change, you can just update the Date table instead of rewriting multiple measures.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team- v-menakakota
Hi Walt1010 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Thank you.- v-menakakota
Hi Walt1010 ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Thank you.