Need Help on NetworkDays Power Query M code

[JustNewbie]

Hi,

Can anyone advise me, if i have 8 columns need to use networkdays, how should i modify the below M code to include all the columns below?  Sample column title below:

1. Days between Invoice date vs Posting date

2. Days between Order date vs Order Processed date

3. Days between Order Processed date vs Shipped date

4. Days between Shipped date vs Received date

Thank you in advance!

[JustNewbie]

@Greg_Deckler can create one networkday function to measure all columns? Or I need to create 4 networkday function if i wan to measure 4 different columns? I don't quite understand....

[Greg_Deckler]

@JustNewbie Um, that's not DAX, that is Power Query "M" code...

[JustNewbie]

Ohhh.. ok i edited the title 😁 thanks

[Greg_Deckler]

@JustNewbie OK, unfortunately not as easy as DAX's NETWORKDAYS function, but @ImkeF has an excellent solution here: Date.Networkdays function for Power Query and Powe... - Microsoft Power BI Community. Also here: Date.Networkdays function for Power Query and Power BI – (thebiccountant.com)