Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Pascal_KTeam's avatar
    Pascal_KTeam
    6 years ago

    Hi

    You can do this in Power Query Editor. 

    Add custom column with formula ="USA"

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You should be able to add a custom column in the Query Editor with the code:

 

= "USA"