Forum Discussion

LLJ1221's avatar
LLJ1221
Helper I
2 years ago
Solved

have the difference between 2 dates dynamically

Hello,   I don't know if my problem has already been asked on the forum but I haven't found any answers.   I have the following table: Transaction Operation number Operation number_1...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • vicky_'s avatar
    vicky_
    2 years ago

    Are you able to simply replace the FIRSTDATE() function above with MIN(). That should return the same result, provided there are no blanks.

vicky_'s avatar
vicky_
Super User
2 years ago

Please try the following: 

dates selected = 
var OPNo = CALCULATE(FIRSTDATE('Table'[date operation]), ALLEXCEPT('Table', 'Table'[Operation number]))
var OPNo1 = CALCULATE(FIRSTDATE('Table'[date operation]), ALLEXCEPT('Table', 'Table'[Operation number_1]))
return DATEDIFF(OPNo, OPNo1, DAY)
  • LLJ1221's avatar
    LLJ1221
    Helper I
    2 years ago

    Hi vicky_ ,

     

    Thanks for your feedback.

     

    I published to specify sue I susu in Direct Query mode and I know that I had already had problems with the "FirstDate" function because it was not supported in direct query mode

    • vicky_'s avatar
      vicky_
      Super User
      2 years ago

      Are you able to simply replace the FIRSTDATE() function above with MIN(). That should return the same result, provided there are no blanks.