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
Helper VThank you for your answer. Why would it be better to avoid using a function like NETWORKINGDAYS and rather use a manual filter?
Community SupportHi 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. - 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.