Networkdays Date diff between two tables

[JustNewbie]

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 errors

Days = Networkdays(DATEDIFF(RELATED(Packing[Date].[Date]),Shipping[Date ].[Date],DAY),1)

Help please... thank you.😊

[JustNewbie]

Hi @amitchandak can help me please? 

[JustNewbie]

Hi, can anyone advise please?

[Anonymous]

Hey @JustNewbie ,
Can you please share a screenshot of the relationship of these two tables and the error that you are getting

[JustNewbie]

Hi @Anonymous  screenshot below

How to make the error go away?

[Anonymous]

@JustNewbie ,
Can you try 

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

Output below: 

[JustNewbie]

@Anonymous 

But it give wrong result...

[Anonymous · Accepted solution]

you have created a column instead of a measure

For a column, it would go as below: 

[JustNewbie]

Can anyone help please?