cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sean123
Regular Visitor

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 ACCEPTED SOLUTION

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



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

1 REPLY 1

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



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors