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

v-caliao-msft's avatar
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's avatar
PorkChop
Advocate I
9 years ago

*flexes*