Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |