Forum Discussion

imrangaslam's avatar
imrangaslam
Frequent Visitor
5 years ago

Relation between two tables

Hello

I have these two tables. How I can do relationship so I can use for different reports in power bi.

I tried to use date table and did 1 to many but not good.

 

Table1(Date)

         Date Table (Date)

Table2(Date)

 

Any possibility to connect both table directly.

 

Thanks

 

Table1

YearMonthDevice categoryUser typeDateChannel groupSessionsRevenueOrders
20202DesktopNew Visitor01/02/2020Organic Search15500
20202DesktopNew Visitor01/02/2020Paid Search4500
20202DesktopNew Visitor01/02/2020Referral813.491
20202DesktopNew Visitor01/02/2020Social900

 

Table2

YearMonthDevice categoryUser typeProduct nameDateChannel groupProduct BrandProduct Category (Enhanced Ecommerce)RevenueOrders
20201DesktopNew VisitorBitzy Biter Teething Ball & Training Toothbrush - Lemon Drop22/01/2020Organic SearchItzyRitzySilicone Teethers14.991
20201DesktopNew VisitorBitzy Biter Teething Ball & Training Toothbrush - Lemon Drop26/01/2020Paid SearchItzyRitzySilicone Teethers14.991
20201DesktopNew VisitorBitzy Biter Teething Ball & Training Toothbrush - Lemon Drop30/01/2020Organic SearchItzyRitzySilicone Teethers14.991
Need Help

1 Reply

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    5 years ago

    Hi imrangaslam 

    Why not create a relationship between Table1[Date] and Table2[Date]? How you want the filters from one of the two tables to filter another table?

     

     

    Best Regards

    Caiyun Zheng