Forum Discussion
Saxon202202
Helper III
Helper IIILookupvalue Return Max Value
I have two tables named "Data" and "Report." The Data table comprises columns such as Area Code, Type, Rack Length, Rack Width, Rack Height, and Volume, which is determined based on the rack dimensi...
Hi,
Try this calculated column formula
Volume = CALCULATE(MAX(DATA[Volume]),FILTER(DATA,(DATA[Area Code]=EARLIER(REPORT[Area Code])&&DATA[Width]>=EARLIER(REPORT[Pack Width])&&DATA[Height]>=EARLIER(REPORT[Pack Height])&&DATA[Depth]>=EARLIER(REPORT[Pack Length]))||(DATA[Area Code]=EARLIER(REPORT[Area Code])&&DATA[Width]>=EARLIER(REPORT[Pack Length])&&DATA[Height]>=EARLIER(REPORT[Pack Height])&&DATA[Depth]>=EARLIER(REPORT[Pack Width]))))Hope this helps.
Saxon202202Helper III
Helper IIIvanessafvg, thank you for your reply.
Basically the small pack data need to be found smaller rack rather than going to bigger rack.
vanessafvg
Community Champion
Community Championbased on what combination, need confirmation, do you only use area code? if you use item and type, how do those link between the tables?