Global Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Merge queries the right way

  • 1.  Merge queries the right way

    Silver Contributor
    Posted Jun 06, 2018 09:35 AM
    ​Hi
    I have 5 queries, with data from up to 23 customers. Some of the rows only have 20-21 of the customers.

    What's the best approach, to merge all those columns, so that I can filter on months, customer etc.
    It comes from an Excel sheet.

    pSFsUF06SAy6aatg5ySp_Data.jpg

    ------------------------------
    Jan G. Laursen
    IT Consultant
    ------------------------------


  • 2.  RE: Merge queries the right way

    Posted Jun 07, 2018 09:22 AM
    Hi Jan,

    I had a similar situation where I had data in 3 distinct columns that I needed to combine into 1 column.  I followed the examples in this link and was able to successfully combine them.
    http://radacad.com/append-vs-merge-in-power-bi-and-power-query

    However, I would love to know if you find a better way to do this.

    Thanks,

    ------------------------------
    Barbara Forsman
    MIS
    NebraskaLink
    Lincoln NE
    4028171425
    ------------------------------