Hi,@athoslar
Regarding the issue you raised, my solution is as follows:
1.First, you'll need to use PowerQuery to add an index column to the table, either starting with 0 or 1.
2.Then create a custom column with the following code:
List.Sum(List.FirstN(#"Added Index"[Unidades Produzidas],[Index]+1))3.Next, the result table is generated with copy table(2):
4.Also generate an index column in the results table:
5.Use a merge query to merge two tables:
6.Expand what you want:
7.Click the button as shown below
8.After removing unnecessary columns, the end result is as follows:
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,@athoslar
Regarding the issue you raised, my solution is as follows:
1.First, you'll need to use PowerQuery to add an index column to the table, either starting with 0 or 1.
2.Then create a custom column with the following code:
List.Sum(List.FirstN(#"Added Index"[Unidades Produzidas],[Index]+1))3.Next, the result table is generated with copy table(2):
4.Also generate an index column in the results table:
5.Use a merge query to merge two tables:
6.Expand what you want:
7.Click the button as shown below
8.After removing unnecessary columns, the end result is as follows:
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Monthly Update - September 2024
Check out the September 2024 Power BI update to learn about new features.
Microsoft Fabric & AI Learning Hackathon
Learn from experts, get hands-on experience, and win awesome prizes.
Fabric Community Update - September 2024
Find out what's new and trending in the Fabric Community.
