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

     

amitchandak's avatar
amitchandak
Super User
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 

 

  • RUPSY777's avatar
    RUPSY777
    Helper II
    5 years ago

    Hi thank you for your response..

    Can you refer to which date you are referring to in the below highlighted syntax?

    var _max = maxx(allselected('Date'), 'Date'[Date])