Forum Discussion

jadhalaoui's avatar
jadhalaoui
Helper I
5 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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)

amitchandak's avatar
amitchandak
Super User
5 years ago

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)