Difference between two dates from one column

[Anonymous]

Dear Community,

I have the following problem with a simple calculation:

I want to calculate the difference between these Dates (like in the first row in this Excel Sheet), (for exmample H1: H2-G2, Column I1: I2-H2...)  - but the Dates are from one column with many datas:

 

I hope you can help with answering this question and thanks a lot for your help!

BR

[amitchandak · Accepted solution]

@Anonymous , I think you need measure , I do not think column will work here

measure =

var _max = maxx(filter(allselected(Table), Table[Date] < max(Table[Date]) ), Table[Date])

return

datediff(_max, max(Table[Date]), day )

Plot with date without time from Table