Forum Discussion
VarunAgw
Jun 12, 2022Copper Contributor
Add a column for user input in power query generated table
I have a table that is filled from a CSV file using a power query. The first column in the CSV is like a "unique identifier" or "key" for a row. In the same table, I have a column named "List 1" ...
Riny_van_Eekelen
Jun 12, 2022Platinum Contributor
VarunAgw You need to look into what is known as "self referencing tables". Google gives you plenty of suggestions on how to set these up. This is the first hit I got.
https://exceleratorbi.com.au/self-referencing-tables-power-query/
VarunAgw
Jun 12, 2022Copper Contributor
Thanks.
I was able to follow the tutorial and implement it. But it feels very hackish solution.
I was able to follow the tutorial and implement it. But it feels very hackish solution.