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)

jadhalaoui's avatar
jadhalaoui
Helper I
5 years ago

Hello amitchandak 

 

Thank you - your DAX got me close to what I need. I am getting however the last Unique Sequence ID to appear in the column instead of the last Pickup_requested_date

 

Have researched MAXX and LASTNONBLANKVALUE - but cannot get the equation to return what I need despite manipulating the LASTNONBLANKVALUE expression

 

 

 

Thanks