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"
Go to Data View. Add new column
Country = "USA"
In Canada
Country = "Canada"