Forum Discussion

jobf's avatar
jobf
Helper II
2 years ago
Solved

Difference between dates in the same column

Hello. I need to create a column or measure that can calculate the difference between two dates in the same column, based on lines from other columns. For example:   Field   Input  Application...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jobf 

     

    You can add a calculated column with this formula

    Duration = 
var _currentDate = 'Table (2)'[Date]
var _previousDate = CALCULATE(MAX('Table (2)'[Date]),ALLEXCEPT('Table (2)','Table (2)'[Field],'Table (2)'[  Input]),'Table (2)'[Date]<_currentDate)
return
DATEDIFF(_previousDate,_currentDate,DAY)

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

jobf's avatar
jobf
Helper II
2 years ago

It's kind of hard to understand, but I'll try to explain. In a field, several inputs will be applied, and these inputs will be applied more than once. I needed to calculate, somehow, the difference between these applications of this input in this specific field. In this case, the difference between the 2nd and 1st and the difference between the 3rd and 2nd.

NaveenGandhi's avatar
NaveenGandhi
Memorable Member
2 years ago

It would be great if you can share some pictures and explain it in detail, The details you have provided is definelty for enough to resolve the problem.

Regards,

Naveen