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.

maruthisp's avatar
maruthisp
Super User
1 year ago

Hi Austen229022,
Instead of doing the step in Power Query, can you try doing with DAX?
Step-1: Create a Date table with excluding weekends and holidays
Step-2: Use the above Date table to join with your table

Best regards,
Maruthi

Austen229022's avatar
Austen229022
Helper II
1 year ago

How can you do this with DAX?