Forum Discussion
Days between two dates columns
Hello community, I'm building a dashboard with Power BI Desktop. I've connected a SQL server database which has two date fields: [Transactiondate] [Closed] What I want to do is get the ...
Thanks for posting - just what I was looking for
Hi all,
How do we calculate the interval between two dates, while excluding the weekends and US holidays. We need this interval to be calculated only for business days, excluding weekends and holidays to have a good measure of performance. Any help is much appreciated. BTW, the interval should be calculated in hours, NOT days or months.
Any help is much appreciated.