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
Super Uservisakhmurukes 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.
