Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Connecting 2 tables question

Hi,   i'm hoping this is a straightworward question..   I have data across 2 tables and need to track by products/ ALL suppliers etc. My issue is that i have 2 supplier columns for different part...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    You can consider using lookupvalue to create a calculated column in the bill table to integrate the data in the other two tables

    Date Due =
SWITCH (
    'Bills Table'[Type],
    "Heavy",
        LOOKUPVALUE (
            'Table Heavy Products'[Date Due],
            'Table Heavy Products'[Product], 'Bills Table'[Product]
        ),
    "Light",
        LOOKUPVALUE (
            'Table Light Products'[Date Due],
            'Table Light Products'[Product], 'Bills Table'[Product]
        )
)

    Best Regards,
    Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks @amitchandak 

 

I'll give this a try. 

 

Will the new Product table auto update if new products are added to Table1 after i've made the Product table?

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi,  Anonymous 

    You can create a Supplier_Product field and create the relationship based on this new field.

     

    But you need to unpivot column"Supplier1" and column “Supplier2” in Table1 first.

    Product Date Due Supplier
    Apples 1/1/2022 H12
    Apples 1/1/2022 G23
    Oranges 2/1/2022 H12
    Oranges 2/1/2022 F34
    Pears 3/1/2022 K32
    Pears 3/1/2022 G23

     

     

    Please check my attached file for more details.

     

    Best Regards,
    Community Support Team _ Eason