Forum Discussion
Solved
Adding a Calculated Column (Date difference) with Values Based On Multiple Rows
Hello! Objective Create a new (5th) column that has the date difference (in rounded up days) between values in two rows for data corresponding to unique customers. The Data Each Order ID co...
jadhalaoui , Not very clear. Try a new column in DAX
Column = var _1 = maxx(FILTER('Table','Table'[Name]= EARLIER('Table'[Name]) && 'Table'[unique customer sequence] < EARLIER('Table'[unique customer sequence])),LASTNONBLANKVALUE('Table'[unique customer sequence],'Table'[pickup_requested])) return datediff(_1,[pickup_requested],hour)
It looks like you are trying to put a DAX expression in a query custom column, which is incorrect. Load your table, and then hit the New Column on the ribbon to enter your DAX column.
Regards,
Pat