Forum Discussion

nikhil893's avatar
nikhil893
New Member
9 years ago
Solved

How to dynamically calculate the difference between two dates selected from a slicer?

  We want to calculate the difference in seconds  between the two dates( start and end) selected from a slicer. As we are very new to this could anyone please help us out?   Thank you, Nikhil Pra...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi nikhil893,

     

    PorkChop's DAX expression works fine.

    Measure = DATEDIFF(MIN(Sales[Date]),MAX(Sales[Date]),DAY)&" Days"

     

    Regards,

    Charlie Liao

nikhil893's avatar
nikhil893
New Member
9 years ago

PorkChop : We need to have the start and end dates to be selected from the user using a slicer. Will this measure work for that too ? We do not have any columns named ' Start date' and 'end date'. We have only one column as date which we are using in a slicer.

PorkChop's avatar
PorkChop
Advocate I
9 years ago

Interesting, maybe you could try

 

=DATEDIFF(min([DATE]),max([DATE]),second)

where [DATE] is the columnname of the slicer you are using?

  • nikhil893's avatar
    nikhil893
    New Member
    9 years ago

    PorkChop : The DATE coulmn may have dates from 1 Nov 2016 till 30 Nov 2016. The selection from the slicer could be 2 Nov (start date) and 4 Nov (End date). We need these two dates ( 2 Nov and 4 Nov) , not the min and max dates in the date column. Will this measure work for that ?

    • PorkChop's avatar
      PorkChop
      Advocate I
      9 years ago

      Well i've not tested it i practice but it should do. When you are filtering using the slicer, it's actually like creating a new table of entries between those two dates. If we then pick the smallest and largest values in that table it's the same effect.

       

      You'll want to test it, as I haven't but syntactically should be correct.