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.

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