Forum Discussion

Timahake8's avatar
Timahake8
Frequent Visitor
11 months ago
Solved

Appending two table within power query, in a way that duplicate is not created for a specific column

I want to append the first three table to create the last table. I do not want the test value for each city in a specific month to be repeated in my new table (I am trying to achieve table 4).
Need Help
  • Timahake8's avatar
    Timahake8
    10 months ago

    Hi v-aatheeque, I have been able to sort the problem in a different way. I needed the test column on my table so a could use it to filter my visual but since I could figure a way to make it work to get the ultimate result I wanted, I just applied the filtering within my model during transformation and solved it. Thank alot

p45cal's avatar
p45cal
Icon for Solution Supplier rankSolution Supplier
11 months ago

How about combining the tables, eg.:

= Table.Combine({Table7, Table8, Table9})

then outputting (loading to) to a pivot table (I've done this in Excel, the Power BI equivalent is, I think, a matrix visual):

Above, the Month_Year and City columns are repeating their item labels:

but the Test column isn't.

Of course, you can filter on any of the columns in this pivot table.

You might prefer for none of the item labels repeating, it might be even clearer: