Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost 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...
Need Help
  • Tahreem24's avatar
    Tahreem24
    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
     

     

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi Ashish_Mathur,

 

Thank you for your reply.  The Invoices issued is correct but it looks like the Number of days is NOT correct.  Maybe I missed something?  Also, is that measure supposed to EXCLUDE the weekends?  Thanks again.

 


 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

You are welcome.  The date slicer should be built from the Calenar Table.