Forum Discussion
Tom_G
Helper II
Helper IITransfer values between tables
Hello, I’m trying to transfer values from one table to another table, which are structurally different. The two demo tables are below Transport Table Shop Name Shop ID Product Name...
Tom_G , Three new columns in DAX in Header table
Bill=
maxx(filter(Transport, Header[Shop Name] =Transport[Shop Name] && header[Shop ID] = Transport[Shop ID]
&& header[Product Name] = Transport[Product Name] && Transport[Driver] ="Bill") , Transport[Driver])
Bob =
maxx(filter(Transport, Header[Shop Name] =Transport[Shop Name] && header[Shop ID] = Transport[Shop ID]
&& header[Product Name] = Transport[Product Name] && Transport[Driver] ="Bob") , Transport[Driver])Ben =
maxx(filter(Transport, Header[Shop Name] =Transport[Shop Name] && header[Shop ID] = Transport[Shop ID]
&& header[Product Name] = Transport[Product Name] && Transport[Driver] ="Ben") , Transport[Driver])
Tom_GHelper II
Helper IIamitchandak thanks a lot, seems to work well