Forum Discussion

Timahake8's avatar
Timahake8
Frequent Visitor
1 year 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
    1 year 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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
1 year ago

Hi Timahake8 ,

 

This looks like an XY Problem to me.

Can you give a bit more detail around what you're actually trying to achieve with the output please? E.g. How are you aiming to report on this Test value? Is it a numerical measure value, or a text/string attribute describing the type of test completed? Etc.
It's perfectly normal for attribute values like this to be duplicated in a fact table, with display requirements being implemented in the front-end/report rather than doctoring the data in Power Query.

 

Pete