Forum Discussion
Adding column with a fixed value
Hi, I have 2 tables: US table: Product Revenue 1 1000 2 2000 3 1000 Canada Table: Product Revenue Country 1 1000 Canada 2 2000 Canada 3 1000 Ca...
Hi
You can do this in Power Query Editor.
Add custom column with formula ="USA"
Anonymous
Just to illustrate how to do this in Power Query:
1) go to Power Query ("Transform Data" in the ribbon
2) select your US Table and choose "Add Custom" from the Add column in the ribbon:
3) Name the new Column "Country" and add the code as shown:
4) Select "Append Queries" from the ribon and choose "Append as new":
5) in the dialogue, select the "Canada" table to append to the US table:
6) and your done - "Close and apply":
Thanks, everyone for your input. I tried adding a custom column but I was just using single quotes, I should have used double-quotes.