Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Add column based on row

‎02-24-2023 07:09 AM

Hi,

I want to add a column based on row 1 below:

 

helpme_0-1677250829416.png

so that I end up with a table with the following headers:

 

Local namePerson IDGenderAgePostcode
Test 1EXAMPLE001Female76XX00 0XX
Test 1............
Test 1............

 

How do I do this?

 

Thanks

Labels:
Message 1 of 6
707 Views
0
5 REPLIES 5
AmiraBedh
Super User
Super User

‎02-24-2023 07:13 AM

Can you please elaborate more the logic behind adding this row ?

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Message 2 of 6
702 Views
0
Anonymous
Not applicable
In response to AmiraBedh

‎02-24-2023 07:21 AM

The situation is that I am setting up an system where files will be uploaded to a folder monthly. The files will come from different companies.

I will then have to combine the files in order to create a report, therefore i need to know which company the file is coming from.

Message 3 of 6
697 Views
0
AmiraBedh
Super User
Super User
In response to Anonymous

‎02-24-2023 07:25 AM

Try to give for each file the name of the company (providing the data), and using the combine feature you will have a column with the name of the company (coming from the filename) will be added.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Message 4 of 6
691 Views
0
Anonymous
Not applicable
In response to AmiraBedh

‎02-24-2023 07:53 AM

The issue with using the file name or Source.name is that it will vary each month and not necessarily give the name of the company

Message 5 of 6
682 Views
0
AmiraBedh
Super User
Super User
In response to Anonymous

‎02-25-2023 08:45 AM

Can you give an example of two or 3 files so I can understand the logic behin?


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Message 6 of 6
637 Views
0

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

View All