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.
I have a 'Calendar' table and a 'Holidays' table.
Please help. i've exhuasted my brain with this one. Thank you.
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.
1 Reply
vicky_Super User
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.