Forum Discussion
Appending two table within power query, in a way that duplicate is not created for a specific column
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
Super UserHi Timahake8 I'm not quite sure if I understand what you mean there. I've based the implementation on your example table as a target:
Map2 + Map3 would be filtered out based on how you set up your target-table. Did you actually want a table like this?
| Month_Year | City | Test | Map | Amount | Colour Rag |
| 30-Apr-25 | Birmingham | 30 | Map 1 | 0,26 | Red |
| 30-Apr-26 | Birmingham | 30 | Map 2 | 0,15 | Yellow |
| 30-Apr-27 | Birmingham | 30 | Map 3 | 0,1 | Yellow |
| 30-May-25 | Birmingham | 40 | Map 1 | 0,22 | Red |
| 30-May-25 | Birmingham | 40 | Map 2 | 0,12 | Yellow |
| 30-May-25 | Birmingham | 40 | Map 3 | 0,27 | Red |
| 30-Jun-25 | Coventry | 31 | Map 1 | 0,16 | Red |
| 30-Jun-26 | Coventry | 31 | Map 2 | 0,16 | Red |
| 30-Jun-27 | Coventry | 31 | Map 3 | 0,11 | Yellow |
With this you can still filter for Test > 30 and won't lose Map2 + Map3. To get this you just need to perform a regular append on your data.
Hi KarinSzilagyi if I use the current test column on a visual to apply where Test > 30, Power bi will have added all the instances of 30 for birmingham as such I wont be filtering right. Many thanks for your input😊. Kindly let me have another think about explaining what I am trying to achieve in a more clearer way.