Forum Discussion

Wegs's avatar
Wegs
New Member
6 years ago
Solved

Calculate DateDeff Between subsequent rows pending Sorting / Filters - Power Pivot

Hello,   New poster here but I have done some extensive research for a couple days now and having a hard time developing the DAX formula for calculating the time difference between one row and the ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

    date diff = datediff(table[timestamp] ,  maxx(filter(table,table[Order Number]=earlier(table[Order Number])
										&& table[timestamp]< earlier(table[timestamp])),table[timestamp]),DAY)
amitchandak's avatar
amitchandak
Super User
6 years ago

Try

date diff = datediff(table[timestamp] ,  maxx(filter(table,table[Order Number]=earlier(table[Order Number])
										&& table[timestamp]< earlier(table[timestamp])),table[timestamp]),DAY)
  • Wegs's avatar
    Wegs
    New Member
    6 years ago

    Excellent Work.  

     

    It seems to work quite well.  I have adjusted it to give me decimal numbers.

     

    Thanks for the quick response!