Hello guys,
have the following problem. My goal is to create a pivot-like table in Excel from a Power BI table. My entries in Power BI are as follows:
Date, Quarter, Product, Price
- 01.01.2024, Q1, Product1, 100$
- 01.01.2024, Q1, Product2, 400$
- 01.01.2024, Q1, Product3, 60$
- 01.01.2024, Q1, Product4, 10$
- 01.01.2024, Q4, Product1, 120$
- 01.01.2024, Q4, Product2, 150$
At the end of the flow, the result should look like this:
Date, Product1Q1, Product2Q1, Product3Q1, Product4Q1, Product1Q4, Product2Q4
- 01.01.2024, 100$, 400$, 60$, 10$, 120$, 150$
It is clear that one timestamps have multiple rows. I would like to compress this into a single row.
My idea was to define a variable for each column, iterate through the rows of the Power BI table, assign the respective values to the variables based on a condition, store them in an array, and then insert them into the table using "Add a row into a table." However, I am missing the logic on how to fill the array and then insert it into the table. Could someone help me with this? Thank you in advance for the help.


Report
All responses (
Answers (