Forum Discussion

tijana_djurovic's avatar
tijana_djurovic
New Member
4 years ago
Solved

Power Pivot, matching terms from two documents

Hi, I am working in a power pivot that uses data from two documents. The unique ID for those two documents is a column called Product.  What I  need is to Product in power pivot that matches with co...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi tijana_djurovic ,

     

    I am not sure if I understood your question correctly. Suppose you have the following example data. 

     

                     

     

    Then you can open Power Query, merge the two tables and expand the [Franchise] column.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi tijana_djurovic ,

     

    You can't delete because it is being referenced by other tables.


    If you don't want it to show up in the workbook, you can delete the corresponding sheet.

     

     

    Best Regards,
    Winniz

tijana_djurovic's avatar
tijana_djurovic
New Member
4 years ago

Hi v-kkf-msft,

Yes, I am expecting double products to show the same Franchise values.

I wouldn't know how to merge these two tables and it seemed easier to me to have two tables. Table Franchise should have served like a VLOOKUP table.

Best regards,

Tijana

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi tijana_djurovic ,

 

I am not sure if I understood your question correctly. Suppose you have the following example data. 

 

                 

 

Then you can open Power Query, merge the two tables and expand the [Franchise] column.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • tijana_djurovic's avatar
    tijana_djurovic
    New Member
    4 years ago

    Thank you v-kkf-msft . This solved my problem. Much appreciated!

    Just one more question: may I delete the second query table now? Table "Franchise" in your example...

    Thanks, 

    Tijana

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      4 years ago

      Hi tijana_djurovic ,

       

      You can't delete because it is being referenced by other tables.


      If you don't want it to show up in the workbook, you can delete the corresponding sheet.

       

       

      Best Regards,
      Winniz