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)

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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

 

jadhalaoui's avatar
jadhalaoui
Helper I
5 years ago

mahoneypat 

 

Sorry if this is an amateur question - but how do I load the table the way you have just mentioned it?

 

Thanks