Forum Discussion
erhan_79
Post Prodigy
Post ProdigyLookup VAlue for repeating values
Hi there ; i need your help for below issue ; i have two table , Table A and Table as below , for both table i have order no , i would like to make lookup value for net price to Table B , but...
please try to create a column in table B
NET PRICE = VAR _MAXDATE = MAXX(FILTER('Table A','Table A'[order no]='Table B'[order no]),'Table A'[document date]) RETURN MAXX(FILTER('Table A','Table A'[order no]='Table B'[order no] && 'Table A'[document date]=_MAXDATE),'Table A'[net price])
SUMMARIZE(
TableA,
TableA[OrderNo],
"LastPrice",LASTNONBLANKVALUE(TableA[DocumentDate],SUM(TableA[NetPrice]))
)- lbendlin
Super User
visakhmurukes Interesting differences in the produced queries
versus
Your version has many more row scans but still comes out better as it avoids the CallbackDataID issue in my version.
erhan_79thanks for info lbendlin but this explaning so technical 🙂 i could not understand sorry , i am not responsible for IT 🙂 , so do you advice me anything else ?
- lbendlin
Use whatever solution you are comfortable with . My comment wasn't directed at you but at the person who (in my opinion) gave you the best solution.
