Forum Discussion

sean123's avatar
sean123
Frequent Visitor
5 years ago
Solved

Add in a new column with static data

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

1 Reply

  • MattAllington's avatar
    MattAllington
    Community Champion

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