Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JustNewbie
Helper I
Helper I

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.😊

1 ACCEPTED SOLUTION

you have created a column instead of a measure

For a column, it would go as below: 

Rushki_0-1668775280881.png

 

View solution in original post

8 REPLIES 8
JustNewbie
Helper I
Helper I

Hi @amitchandak can help me please? 

JustNewbie
Helper I
Helper I

Hi, can anyone advise please?

Rushki
Regular Visitor

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

Hi @Rushki  screenshot below

JustNewbie_0-1668743218229.pngJustNewbie_1-1668743278211.png

How to make the error go away?

@JustNewbie ,
Can you try 

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

Output below: 
Rushki_0-1668759697335.png

 

@Rushki 

 

But it give wrong result...

JustNewbie_0-1668763214018.png

 

JustNewbie_1-1668763262597.pngJustNewbie_2-1668763281567.png

 

you have created a column instead of a measure

For a column, it would go as below: 

Rushki_0-1668775280881.png

 

JustNewbie
Helper I
Helper I

Can anyone help please?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.