calculate number of days between 2 dates except weekend and free days

[asmaG]

hello ,  i'm working with power bi RS and
i'm trying to calculate number of days between startdate and enddate except the week end and free day but i haven't found

any idea please

thank you

[josef78]

Try NETWORKDAYS function

[asmaG]

i tried it but it did'nt accept it it's not a regonized function i'm work with power bi rs Version: 2.105.1143.0 64-bit (mai 2022)

[josef78]

It is relatively new function, you must upgrade least to September 2022 (or bettter to last version).

Power BI Report Server September 2022 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

[asmaG]

i don't have the permission to made it because i work with client computer and it's gonna take a long long time to have those permission 😕

[josef78]

Try ask our client to upgrade Power BI Desktop, there is additional reason, May 2022 version is out of support. Currently supported versions are: Jan2023, May2023 and Sep2023.

[asmaG]

i add a holidays table date that containt all days not to count but after that when a i made a datediff it doesn't take all except my holidays table

[ShirinArshadnia]

hi @asmaG 

If you are looking for a simple way you should have a Date Dimesion correctly connected to your facts tables .

so you can have a measure which can simply calculate the date diff between the two dates ,

(a good date dimension is the one which have working days (as a flag for example 1) and weekend days (0).

if this is helpful for you please mark it as a solution .

[asmaG · Accepted solution]

hello , i finally found a solution

here the dax function that i used after creating a date table that containt holidays days

test_wee = RoundDown(DateDiff(t_faits[DATE_1], t_faits[DATE_2], Day) / 7, 0) * 5 +

Mod(5 + Weekday(t_faits[DATE_2]) - Weekday(t_faits[DATE_1]), 5)- calculate ( COUNT ( calendrier[Date] ), FILTER ( calendrier,t_faits[DATE_1] <= calendrier[Date]

&& t_faits[DATE_2] >= calendrier[Date]

&& ( calendrier[isholiday] = 1)))