Forum Discussion

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

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

Advocate I

9 years ago

Hey dude.

If you are doing this in dax it's super simple.

=DATEDIFF([Startdate],[EndDate],second)

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.
- v-caliao-msft
  Microsoft Employee
  9 years ago
  Hi nikhil893,
  
  PorkChop's DAX expression works fine.
  
  Measure = DATEDIFF(MIN(Sales[Date]),MAX(Sales[Date]),DAY)&" Days"
  
  Regards,
  
  Charlie Liao
  - PorkChop
    Advocate I
    9 years ago
    *flexes*
- 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
    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 ?