Forum Discussion
Coryanthony
Helper III
Helper IIIPlease help with new calculated column
I am attemping to create a column measuring amount of business day between [Adjusted Date] and [Action Date]. [Adjusted date] = date request came in [Action Date] = date operator took action. ...
Have you tried using the NETWORKDAYS function: https://learn.microsoft.com/en-us/dax/networkdays-dax
You'll can pass in your holidays table and it automatically handles weekends for you. Hope this helps.
vicky_
Super User
Super UserHave you tried using the NETWORKDAYS function: https://learn.microsoft.com/en-us/dax/networkdays-dax
You'll can pass in your holidays table and it automatically handles weekends for you. Hope this helps.