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

 

Add a calculated column to US Table.

 

Country = "US"