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...
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
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