Forum Discussion

patrickoleary85's avatar
patrickoleary85
Frequent Visitor
2 years ago
Solved

DAX for datediff of values different rows

Hi, I am trying to use datediff in a column to gather the number of days between two events. I'm unable to produce the data. I think it something small I am missing, but I cannot figure it out.    ...
DATEDIFF
  • v-yanimei-msft's avatar
    v-yanimei-msft
    2 years ago

    Hi patrickoleary85 , 

    Based on your response, I understand that you want to see the date difference for all users. So, I made a modification to the test table Table as shown in the image. New column Diff between Receipt and Results and input:

     

    Diff between Receipt and Results = 
   VAR A = MAXX(FILTER('Table',EARLIER('Table'[User])  = 'Table'[User]),'Table'[Created].[Day])
   VAR B = MINX(FILTER('Table',EARLIER('Table'[User])  = 'Table'[User]),'Table'[Created].[Day])
   RETURN
   IF('Table'[Document Type]="Receipt",B-A,A-B)

     

    You can modify the DAX code according to your needs. Hope it works for you!

     

    Best Regards,

    Caroline Mei

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Joe_Barry's avatar
Joe_Barry
Icon for Solution Sage rankSolution Sage
2 years ago

Hi patrickoleary85 

 

Do the Results date and Receipts date appear in the same line in the table? Create a calculated columns and add the measure below, relacing the Table with your table name. I hope this helps!

Diff = DATEDIFF(Table[Results date], Table[Receipts date], DAY)

 

If you found my answer helpful and it solved your issue, please accept as solution

  • patrickoleary85's avatar
    patrickoleary85
    Frequent Visitor
    2 years ago

    Hi and thank you, Joe! This wasn't successful for me. The items are not on the same line/row. So the two types of Document Type look at the same Created column