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: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

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
1,105 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
1,100 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
1,095 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
1,089 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
1,080 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
1,035 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All