Forum Discussion
Calculate difference between two dates in Minutes
Hi all So i have two dates, One is the [Created Date] and One is the [Completed Date]. I was able to calculate the difference between these based on Work Days(ie Exclude Holidays and Weekends...
Anonymous , There is blog around business hour. See if that can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Anonymous , There is blog around business hour. See if that can help
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Thank you - i actually found Part 2 of the link you sent more useful and easier to digest(and it worked).
For anyone looking at this in the future, the linked provided by Amit works but Part 2 works too: https://exceleratorbi.com.au/calculating-elapses-business-hours-using-dax-part-2/