Welcome back to this week’s edition of the Power BI
blog series. This week, we look at a new yet eerily familiar DAX
function, NETWORKDAYS.
There’s a new DAX
function to add the family: NETWORKDAYS. This function returns the number of whole
working days between two days. You
should note that you may use any way of expressing a date in Power BI to
specify the start and end dates, including the dt“YYYY-MM-DD” notation.
Working days exclude
weekends, which are customisable using the optional weekends parameter. By default, this function will use Saturday
and Sunday as the weekend days. Any
dates provided in an optional holidays parameter will also be excluded when
calculating working days.
For example, the
following will return a result of 20 working days:
WorkingDays := NETWORKDAYS(DATE(2022,10,1), dt”2022-10-30″)
For reference, 1
October 2022 is a Saturday, and 30 October 2022 is a Sunday.
The following
returns 21 working days, because it specifies the weekend to be Friday and
Saturday:
WorkingDaysFriSat := NETWORKDAYS(DATE(2022,10,1),
dt”2022-10-30″, 7)
Finally, the
following returns a result of 19 working days, because it specifies two working
days in the timespan as holidays:
WorkingDaysFriSatHolidays :=
VAR _holidays = {DATE(2022, 10, 3), DATE(2022, 10, 4)}
RETURN NETWORKDAYS(DATE(2022, 10, 1), dt”2022-10-30″, 7,
_holidays)
Check back next week for more Power BI tips
and tricks!
Be the first to comment