Forum Discussion
Solved
Transfer 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])
amitchandak thanks a lot, seems to work well