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.
Hello!
I am running into an issue when I run a power query on transposed data.
I recieve reports in rows:
1 2
Site Name: xyz
Cost: $$
Sq. Ft: ##
etc.
When I upload the source file via folder the data comes back to me stacked. Therefore when I transpose the data in order to make column 1 my row headers all of my information is listed in the same row. I would like to create a new row under the same column header for each report. Is this possible?
Hi @Tylerspears27,
I recieve reports in rows:
1 2
Site Name: xyz
Cost: $$
Sq. Ft: ##
etc.
When I upload the source file via folder the data comes back to me stacked. Therefore when I transpose the data in order to make column 1 my row headers all of my information is listed in the same row. I would like to create a new row under the same column header for each report. Is this possible?
If I understand your scenario correctly that you have several tables with the similar values and you want to get the output below.
You could follow the steps to get the output above.
1. Go to Query Editor, and transpose your columns to get Site name , cost and SQ as Columns. Do this operator for each table.
2. Click Use First Row as Headers
3. Click Append.
In addition, you could refer to my pbix file.
Best Regards,
Cherry
Thank you for your response.
I am curious if there is a way to automate this process. I do not want to upload each file individually then append them together each time a new report is generated. Currently I have it pulling from a folder source and therefore not able to append the tables together from the same sheet. Is there any way around this problem?
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |