Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
diegoadum
Helper I
Helper I

use a cell value to fill a column

Hi there! I'm trying to fill up a column with the Country information from where the info belong to. The country name is located in a particular Excel cell. Is there a way to do that?

 

Many thanks in advance!

 

PS: The country is also part of the name of each excel file, so that could work also if there is a way to read it into power bi.

1 ACCEPTED SOLUTION
diegoadum
Helper I
Helper I

Well, I did some movements and got what I was looking for. Basically, I load a copy of the same excel file and using the query editor, I took off all the columns but the one that have the country name on one of the cells. Them, I remove the previous rows (3) and them I used the function which keep the upper rows. At this point the only one I need if the first row, which has the Country name. Them I append the 2 tables. The result at this point looks like a new column added to the previous ones but the new column only have data in the first row, which is the country. Using the fill up function I populated the country name on all the rows and as the last step I have to remove the first row in this view. The final result, I got a new column with the country name for each Excel file I loaded. 

View solution in original post

1 REPLY 1
diegoadum
Helper I
Helper I

Well, I did some movements and got what I was looking for. Basically, I load a copy of the same excel file and using the query editor, I took off all the columns but the one that have the country name on one of the cells. Them, I remove the previous rows (3) and them I used the function which keep the upper rows. At this point the only one I need if the first row, which has the Country name. Them I append the 2 tables. The result at this point looks like a new column added to the previous ones but the new column only have data in the first row, which is the country. Using the fill up function I populated the country name on all the rows and as the last step I have to remove the first row in this view. The final result, I got a new column with the country name for each Excel file I loaded. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.