Calculate Number of Days between 2 dates excluding weekends

[Abduvali]

Hi All,

I'm trying to calculate a number of days between two dates without weekends:

• I have Order Date and a Shipment Date
• I have created Calendar table to use the following approach: 

But I'm not getting any results back my new TAD column is blank =o?

Here is my dax formula i'm using: 

I have created a new column in Dates table:

• IsWorkDay = SWITCH(WEEKDAY('Date'[Date],2),6,0,7,0,1)

Then I'm creating a new TAD column to get number of days excluding weekends:

• TAD = CALCULATE(SUM('Date'[IsWorkDay]),
              DATESBETWEEN('Date'[Date],'Master Sheet'[Ord Date],'Master Sheet'[Ship Date]))

Am I doing something Wrong here???

Thank you.

Regards

Abduvali

[Abduvali · Accepted solution]

Hi All,

It's actually was a bug after restarting Power BI its solved itself =oD

Regards

Abduvali

[BigKev]

Hey Abdulvali,

When I used your TAD formula, it returns me with an error saying that a single value for column Due Date cannot be determined

This is my data structure

Do you know what I did wrong here?

Cheers,

Kev

Cheers,

Kev

[ssvr]

after applying your steps i got wrong output

Please help me out

[v-yulgu-msft · Accepted solution]

Hi @Abduvali,

Glad to hear that you have solved this problem. Would you please mark your sharing resolution as an answer so that it might help more users?

Regards,

Yuliana Gu

[Abduvali · Accepted solution]

Hi All,

It's actually was a bug after restarting Power BI its solved itself =oD

Regards

Abduvali