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...
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)

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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks so much amitchandak 

    Worked perfectly!