Forum Discussion
Solved
Power Query Duration between Dates excluding Weekends Wont Load
I am using a database to import rows of details into my dashboard, with a calculation of working days between the Received and the Issued dates. There are around 120k rows, and only have Case ID, Rec...
Hi Austen229022,
I have reproduced your scenario in Power BI as per your requirements. Please find attached
.pbixfile for your reference.If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.
Thank you.
Hi,
It may be better to do this in DAX as a calculated column formula. Share some data to work with and show the expected result. Also share the list of public holidays.