Forum Discussion
Syndicate_Admin
2 years agoAdministrator
Cumulative Sum Table
Greetings colleagues, I'm new to power BI, I'm doing the mundanza from excel to power bi and I ran into a problem. I have data of this style And I want to want a board or matrix with this st...
- 2 years ago
It seems to me that I have the solution, although there is always room for improvement, I share the file with you.
As I said at the beginning, I managed to do it with a row_number as an id, I still don't know if it's the best solotion, but it seems to funionize.
Thank you very much in advance for the help and I hope you can be helpful.
This type of table is very useful if you want to create time series with the maturation of different years.I look forward to hearing from you.
Thank you very much in advance.
Greg_Deckler
2 years agoCommunity Champion
Syndicate_Admin Add an Index column in Power Query Editor and Year column YEAR([fecha]) as DAX in the Desktop. Then a running total measure: Better Running Total - Microsoft Fabric Community