Calculate Date subtracting business days

[Anonymous]

I am trying to calculate a particular date using transit time. However i only want to use the business transit days in that calculation. Essentially i want to take a delivery date subtract the business days in the transit time and get that date. Is it possible? How would i go about setting that up using DAX logic?

[Icey · Accepted solution]

Hi @Anonymous ,

Please check my reply in this post: Solved: Calculate time difference of 2 dates in conditiona... - Microsoft Power BI Community.

The DAX expressions calculate datadiff only within Work hours. 

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous see the attached solution, you can tweak it as per your need. I did this for another post but will give you an idea of how to go about it.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡