Please help with new calculated column

[Coryanthony]

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.

[vicky_ · Accepted solution]

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.