Forum Discussion
Dimi_2207
Helper I
Helper ITo show previous value based another column in DAX
Hello ! I have a big set of data and need to show in the column "Previous agent" the agent who took the previous call from the same phone number, please see the example below: Date Phone ...
Hi,
Write this calculated column formula
Column = LOOKUPVALUE(Data[Agent],Data[Date],CALCULATE(MAX(Data[Date]),FILTER(Data,Data[Phone]=EARLIER(Data[Phone])&&Data[Date]<EARLIER(Data[Date]))),Data[Phone],Data[Phone])Hope this helps.
Dimi_2207Helper I
Helper IThank very much !
Works perfectly
Ashish_Mathur
Super User
Super UserYou are welcome.