Forum Discussion

imrangaslam's avatar
imrangaslam
Frequent Visitor
5 years ago

How to do 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

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    5 years ago

    Hello imrangaslam 

     

    whats the problem to connect them through a date-table?

    This is the way to connect a many to many relationship

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy