Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi All,
I'm trying to use networkdays function to calculate difference between dates. With help of this difference I need to generate status.
For one case where difference is negative I'm getting error & not sure how I can show negative number?
Can someone please help me out how I can generate negative number?
Regards,
Sumit
By networkdays you mean the DAX function, correct?
https://learn.microsoft.com/en-us/dax/networkdays-dax
Can you provide an example when the returned number is expected to be negative?