Number of working days between slicer dates

[barryjarvis]

I have a table of data with a 'CreatedOn' date column, I currently use a slicer to filter the report by those dates.

I'd like to get the number of working days between those two dates.

I've found some examples of this question previously, but they seem to have two columns of dates (i.e. start date | end date) so don't really match what I'm trying to do.

Can somebody point me in the right direction for this please?

[Anonymous]

Hi @barryjarvis,

You could look into using the min and max functions with the datediff function. 

Measure = DATEDIFF(min(Query1[Date]), max(Query1[Date]), DAY)

If you would like to calculate working days between the 2 dates, you will need to have a column in your table indiciatnig whether it is a working or non working day. 

You can then calculate the number of non-working days between your selection and subtract it from the days between the start and end date in your selection to get the number of working days between the range. 

Im new to powerbi myself and this may not be the best approach but it does do the trick. Below is the dax code for the measure

Measure =
var weekends = COUNTROWS(FILTER(Query1, Query1[isWorkingDay] = False()))
var totaldays = DATEDIFF(min(Query1[Date]), max(Query1[Date]), DAY)

return totaldays - weekends