I want to calculate the "working days" between 2 dates in power bi. Middle east and north africa countries have different weekends (for example Egypt and Saudi Arabia Fri,Sat, the rest Sat,Sun).
In excel it is:
(IF(OR(J2="Saudi Arabia", J2="Egypt"), NETWORKDAYS.INTL(AU2, AW2, 7),NETWORKDAYS.INTL(AU2, AW2, 1))))-1
how can I convert it to Power BI DAX?
Does any of you have such experience?
Note: J2 : Country name AU2 : Start Date AW2 : End Date