Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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
    4 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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Create common dimension product and supplier and date. join with both tbales

 

example

Product = distinct(union(distinct(Table1[Product]),distinct(Table2[Product]) ))

 

refer

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

 

 

for date

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.