Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating Number Of Days Between Two Selected Dates

Hi Everyone, 

 

Does anyone know how to do the following: 

 

1. Calculate the number of days between two dates, based on slicer selection. The slicer has to be the 'Between' one where you need to input two dates. 

 

2. Then based on the number of days, perform a count of how many sales were made between and including those dates. 

 

Because the date has to be a range, i have no idea how this works. Does 'SelectedValue' still make sense?

 

Thanks in advance!

Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a new measure like

     

    diff =
    var _min =minx(allselected(date),date[date])
    var _max =maxx(allselected(date),date[date])
    return
    return datediff(_min,_max,day)

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try a new measure like

     

    diff =
    var _min =minx(allselected(date),date[date])
    var _max =maxx(allselected(date),date[date])
    return
    return datediff(_min,_max,day)