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

CahabaData's avatar
CahabaData
Memorable Member
8 years ago

So it probably should be pointed out that a side-by-side merge of 2 days, just one time is fine.  But if the data is coming in daily, then this approach cannot scale.

 

Instead the data should be appended into a single table in a normal structure:

 

Keywords     Date   Position

A                7/8/17    10

B                7/8/17    11

A                7/9/17    20       
B                7/9/17    21

etc

 

Then rely on Matrix visual or transform as part of the visual display and not as part of the table model.

 

  • Kid_Koala's avatar
    Kid_Koala
    Frequent Visitor
    8 years ago

    Much thanks for your answer, CahabaData

    Sure, I understand the scalability thing. Just needed that one for a one time report.