Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Year | Month | Device category | User type | Date | Channel group | Sessions | Revenue | Orders |
2020 | 2 | Desktop | New Visitor | 01/02/2020 | Organic Search | 155 | 0 | 0 |
2020 | 2 | Desktop | New Visitor | 01/02/2020 | Paid Search | 45 | 0 | 0 |
2020 | 2 | Desktop | New Visitor | 01/02/2020 | Referral | 8 | 13.49 | 1 |
2020 | 2 | Desktop | New Visitor | 01/02/2020 | Social | 9 | 0 | 0 |
Table2
Year | Month | Device category | User type | Product name | Date | Channel group | Product Brand | Product Category (Enhanced Ecommerce) | Revenue | Orders |
2020 | 1 | Desktop | New Visitor | Bitzy Biter Teething Ball & Training Toothbrush - Lemon Drop | 22/01/2020 | Organic Search | ItzyRitzy | Silicone Teethers | 14.99 | 1 |
2020 | 1 | Desktop | New Visitor | Bitzy Biter Teething Ball & Training Toothbrush - Lemon Drop | 26/01/2020 | Paid Search | ItzyRitzy | Silicone Teethers | 14.99 | 1 |
2020 | 1 | Desktop | New Visitor | Bitzy Biter Teething Ball & Training Toothbrush - Lemon Drop | 30/01/2020 | Organic Search | ItzyRitzy | Silicone Teethers | 14.99 | 1 |
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
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |