Forum Discussion
Difference between two dates from one column
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
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
1 Reply
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