Forum Discussion
How to Normalize these 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 Ta...
I would unpivot Table 1 to put sessions, revenue and orders into separate rows (or even better, into separate tables)
The user ID seems to be missing from both tables. What do you think the relationship column should be? I don't think the date is a good candidate at all.