Forum Discussion

Oros's avatar
Oros
Post Prodigy
2 years ago
Solved

Count working days

Hello,   I am looking for a measure to count the number of days based on the selected date range in the date slicer.  Thanks.   I am definitely missing a filter in this measure because the result...
  • Tahreem24's avatar
    2 years ago

    Oros  Try this measure:

    Date Try =
     var _max = maxx(ALLSELECTED('financials'),'financials'[Date])
    var _min = minx(ALLSELECTED('financials'),'financials'[Date])
    return
    datediff(_min,_max,day)+1