Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
Can you please support with the following DAX.
I try to calculate networking day between 2 dates, excluding holidays and weekend.
My holidays table is multi-dimensional, it covers every countries. I tried this but it is not a valid syntax...
= NETWORDAYS( _startdate, _enddate, 1, VALUES(date, country = "FR"))
Best.
Solved! Go to Solution.
=
NETWORKDAYS (
_startdate,
_enddate,
1,
DISTINCT (
SELECTCOLUMNS ( FILTER ( 'Holidays', [country] = "FR"),"Date",[date] ) )
)
)
=
NETWORKDAYS (
_startdate,
_enddate,
1,
DISTINCT (
SELECTCOLUMNS ( FILTER ( 'Holidays', [country] = "FR"),"Date",[date] ) )
)
)
Just trying your solution and it works well. Little bit tricky but I will remember the tips.
thanks a lot for your help 🙂
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |