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?

  • v-priyankata's avatar
    v-priyankata
    Community Support
    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 

      May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

      Thank you