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

amitchandak  - Thank you for your response.

 

From Transform Data > Add Column > Custom Column - I tried the following and got the error Token EoF Missing

 

 

mahoneypat 

 

Thanks - found out how to do it. 

 

Getting an error about comparing values of type Number and values of type Text. Debugging as we speak.

 

I need to get a better command of the functions and syntax. Will be looking into it