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 hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.