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])
ryan_mayu
Super User
Super Userplease 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])- lbendlin
Here is a version that also gets the Totals right.
