Forum Discussion

Tom_G's avatar
Tom_G
Helper II
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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])