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
    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.


    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.

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


    Barbara Forsman
    Lincoln NE