Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I want to add a column based on row 1 below:
so that I end up with a table with the following headers:
Local name | Person ID | Gender | Age | Postcode |
Test 1 | EXAMPLE001 | Female | 76 | XX00 0XX |
Test 1 | ... | ... | ... | ... |
Test 1 | ... | ... | ... | ... |
How do I do this?
Thanks
Can you please elaborate more the logic behind adding this row ?
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.
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.
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
Can you give an example of two or 3 files so I can understand the logic behin?
User | Count |
---|---|
98 | |
76 | |
76 | |
49 | |
27 |