Calculating working days considering different weekends - Power BI DAX
07:40 03 Nov 2025

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

date powerbi dax