Forum Discussion

Kid_Koala's avatar
Kid_Koala
Frequent Visitor
8 years ago
Solved

Issue with merging data while using Power Bi for SEO

I'm using Power Bi for SEO, position analysis. Got two tables. First be like: Keywords    Position on 7/08/2017 A                                10 B                                11 C        ...
Need Help
  • SivaMani's avatar
    SivaMani
    8 years ago

    Hi Kid_Koala,

     

    Merge Table 2 with Table 1

     

     

    Then Expand,

     

    There is no duplication. I guess this is what you are looking for. Correct me if I'm wrong

BeemsC's avatar
BeemsC
Resolver III
8 years ago

Hello,

If you have a relationship between the 2 tables:
Just go to the query editor -> go to the table you want to add the column too -> On the top of ur screen select Add column -> Select custom column -> Insert the data you want to add -> Apply changes

If something is unclear let me know.
Good luck !

Kid_Koala's avatar
Kid_Koala
Frequent Visitor
8 years ago

Thanks for your message, BeemsC.

Unfortunately, that didn't help. There is a relations between those two tables, however, when I click 'custom column' I can only choose from the first table columns. When I try to do the same with the second one, I only can choose from the second table columns.