DAX Lookupvalue help please

[berkero]

Hello everyone ,

I need a help about a lookupvalue dax formula for the same table. I have the columns like the example and need to write the "Previous Visit End Time" whit dax formula.

May i ask your help please. Thank you in adavnce

[Daniel29195 · Accepted solution]

@berkero 
try the following 

create a calculate column as follow.: 

col = 

Var ds =

offset ( -1, 

summarize ( 

tbl_name, 

tbl_name[representative id], 
tbl_name[visit date] , 

tbl_name[visit queue], 

tb_name[visitend time]
) , 

orderby(tbl_name[visit_queue] , asc ) , 

partitionby(tbl_name[representative id] , tbl_name[visit date] )

)

return 

selectcolumns(

ds, 

"res" , tbl_name[visitend time] ) 

let me know if this works for you . 

if this helped you solving your problem, 

make sure to give it a thumbs up and accept it as a solution so others can find it quickly. 

[Ashish_Mathur · Accepted solution]

Hi,

This calculated column formula works

Column = CALCULATE(MAX(Data[Visit End Time]),FILTER(Data,Data[Representative ID]=EARLIER(Data[Representative ID])&&Data[Visit Date]=EARLIER(Data[Visit Date])&&Data[Visit End Time]<EARLIER(Data[Visit End Time])))

Hope this helps.

[berkero]

thank you so much.. it works..

[Ashish_Mathur]

You are welcome.

[Daniel29195 · Accepted solution]

@berkero 
try the following 

create a calculate column as follow.: 

col = 

Var ds =

offset ( -1, 

summarize ( 

tbl_name, 

tbl_name[representative id], 
tbl_name[visit date] , 

tbl_name[visit queue], 

tb_name[visitend time]
) , 

orderby(tbl_name[visit_queue] , asc ) , 

partitionby(tbl_name[representative id] , tbl_name[visit date] )

)

return 

selectcolumns(

ds, 

"res" , tbl_name[visitend time] ) 

let me know if this works for you . 

if this helped you solving your problem, 

make sure to give it a thumbs up and accept it as a solution so others can find it quickly. 

[berkero]

It works.. thank you so much