Forum Discussion

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 errors

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

Help please... thank you.😊

Anonymous
3 years ago
you have created a column instead of a measure

For a column, it would go as below:

8 Replies

JustNewbie
Helper I
3 years ago
Can anyone help please?
Anonymous
Not applicable
3 years ago
Hey JustNewbie ,
Can you please share a screenshot of the relationship of these two tables and the error that you are getting
- JustNewbie
  Helper I
  3 years ago
  Hi Anonymous screenshot below
  How to make the error go away?
  - Anonymous
    Not applicable
    3 years ago
    JustNewbie ,
    Can you try
    NetWD = NETWORKDAYS( MAX(Packing[Date]), MAX(Shipping[Date]))
    
    Output below:
JustNewbie
Helper I
3 years ago
Hi, can anyone advise please?
JustNewbie
Helper I
3 years ago
Hi amitchandak can help me please?