EXCEL formula to dax in power bi

[Anonymous]

I need this excel formule to work in Power bi:

=ALS([@[Order Uitgewerkt?]]="yes";ALS([@[engineering ready]]-[@[Order Really in]]<0;0;NETTO.WERKDAGEN([@[Order Really in]];[@[engineering ready]];Holidays__2[Datum]));NETTO.WERKDAGEN([@[Order Really in]];VANDAAG()+[@[Leadtime based on Complexity & training]];Holidays__2[Datum]))

Rifht now I have this:

= IF([Order uitgewerkt] ="Yes",IF(DATEDIFF([Engineering ready],[Order in],DAY)<6,0,

As you can see it I get stuck on network days, because there isn't a function for this in Power Bi. Does anyobody knows how to solve this?

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[Anonymous]

Hi @amitchandak , sorry the excel formula is in Dutch.

Right now i have this power bi formula;

 = IF([Order uitgewerkt] ="Yes",IF(DATEDIFF([Engineering ready],[Order really in],DAY)<0,0,DATEDIFF([Order really in],[Engineering ready],DAY)),DATEDIFF([Order really in],TODAY()+[Leadtime based on Complexity & training],DAY))

This formula works for me, but it includes weekends in the date differance. The part of formule that i marked with bold letters includes weekends and i need to exclude them. So i need the date differance networkdays, but i don't know how I can do that

In excel you have a formula for this ; "Networkdays", but there isn't one in power bi. 

I translated the excel formula that is used. Maybe now you understand better what i need

=IF([Order Uitgewerkt?]="yes";IF([engineering ready]-[Order Really in]<0;0;NETWORKDAYS([Order Really in];[engineering ready];Holidays__2[Datum]));NETWORKDAYS([Order Really in];TODAY()+[Leadtime based on Complexity & training];Holidays__2[Datum]))

I hope it is clear for you what i need. Story short; now the formula includes weekends and i need networkdays. If you have any questions please ask.