Forum Discussion

Austen229022's avatar
Austen229022
Helper II
1 year ago
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...
Need Help
Show and Tell
Tips and Tricks
  • v-priyankata's avatar
    v-priyankata
    1 year ago

    Hi Austen229022,

    I have reproduced your scenario in Power BI as per your requirements. Please find attached.pbix file 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.

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi Austen229022 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.