Forum Discussion

PBI-Newbie's avatar
PBI-Newbie
Helper I
3 years ago
Solved

Dynamic Networkdays function with Dates from Slicer - Working Days

Dear all,    I am trying to have a measure that calculates the following: Networkdays for a selected time period (chosen from the slicer "Date" from Calendar Table). I have a holiday calendar and...
  • PBI-Newbie's avatar
    PBI-Newbie
    3 years ago

    Thanks a lot Anonymous ! In the meantime I use three different measures to get the desired calculation. 

    • Calendar Last Date=Calculate(Lastdate('Calendar[Date]))
    • Calendar First Date=Calculate(Firstdate('Calendar[Date]))
    • Networkdays([Calendar First Date],[Calendar Last Date],1,Values(Calendar_Holidays[Date]))

    Might not be elegant, but worked out as well 🙂

PBI-Newbie's avatar
PBI-Newbie
Helper I
3 years ago

Thanks a lot Anonymous ! In the meantime I use three different measures to get the desired calculation. 

  • Calendar Last Date=Calculate(Lastdate('Calendar[Date]))
  • Calendar First Date=Calculate(Firstdate('Calendar[Date]))
  • Networkdays([Calendar First Date],[Calendar Last Date],1,Values(Calendar_Holidays[Date]))

Might not be elegant, but worked out as well 🙂