Forum Discussion

JustNewbie's avatar
JustNewbie
Helper I
3 years ago
Solved

Networkdays Date diff between two tables

Hi, I have 2 different connected tables. How do i include the Networkdays in the Dax below? Days = DATEDIFF(RELATED(Packing[Date].[Date]),Shipping[Date ].[Date],DAY)   I try this but it give me ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    you have created a column instead of a measure

    For a column, it would go as below: 

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

JustNewbie ,
Can you try 

NetWD = NETWORKDAYS( MAX(Packing[Date]), MAX(Shipping[Date]))

Output below: 

 

JustNewbie's avatar
JustNewbie
Helper I
3 years ago

Anonymous 

 

But it give wrong result...

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    you have created a column instead of a measure

    For a column, it would go as below: