Forum Discussion

RUPSY777's avatar
RUPSY777
Helper II
5 years ago
Solved

Display data using date slicer having multiple

For a user given date range(single column)display data   Requirement: starting before the start date and ending at the end date starting before the start date and ending before the end date star...
General Comment
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    RUPSY777 , With an independent date table

     

    measure =
    var _max = maxx(allselected('Date'), 'Date'[Date])
    var _min = minx(allselected('Date'), 'Date'[Date])
    return
    calculate(count(Table[Inventory item]), filter(Table, Table[Start Date] >=Min && Table[End Date] = _max))

     

    same way build others 

     

  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, RUPSY777 

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Please share some sample data( in excel ) and expected result.It will help to provide the appropriate solution. 

     

    Best Regards,
    Community Support Team _ Eason

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, RUPSY777 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Please share some sample data( in excel ) and expected result.It will help to provide the appropriate solution. 

 

Best Regards,
Community Support Team _ Eason