Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Connecting two data sets

Essentially I have two data sets which are talking about the same thing, let's say sign ups. But one already has sign-ups per month and the other has sign-ups recorded as single items. Both of these ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi Anonymous 

     

    If they have some common columns, you may have a look at the Merge queries feature in Power Query. It should be helpful. 

    Merge queries overview - Power Query | Microsoft Learn

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

  • AnkitKukreja's avatar
    AnkitKukreja
    3 years ago

    Hi Anonymous 

     

    You can create a new SharePoint where you can merge these files or you can use merge in Power BI to get data in a single table. If you can share the table structure then it might open other options to be explored.

     

     

AnkitKukreja's avatar
AnkitKukreja
Super User
3 years ago

Hi Anonymous 

 

You can create a new SharePoint where you can merge these files or you can use merge in Power BI to get data in a single table. If you can share the table structure then it might open other options to be explored.