Add in a new column with static data

[sean123]

Hello,

The data I am importing to Power BI does not have a required regional name in the data. I'd like to (if this is possible) add a column called Region and then insert APAC all the way down. The data I am importing is always going to come from APAC and therefore this regional information ("APAC") will not change. Is it possible to add this extra column is while "Transforming" the data in Power BI Query?

Thank you

[MattAllington · Accepted solution]

Yes. Go to Add Column\Custom Column and enter "APAC" including quotes.