Forum Discussion
Cumulative Sum Table
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.
Hi Syndicate_Admin ,
The standard approach in Power BI is as provided by Ashish_Mathur which involves creating a calendar table and leveraging the time intelligence function available in DAX.
Regarding your example provided, I am wondering why your "mes" (month I suppose) is running up to 14 instead of 12. Is this intentional or it was not intended? If it runs up to 14 like posting period in SAP, you may need to create a summarized table of that to create one to many relationship with your fact table if you want to analyse by mes of up to 14 instead of 12.
Best regards,
It was placed intentionally, since what I want is to see "matured" data by year, so if I am going to analyze 3 years I would have, for 2022, I would have (12+12+5) periods, for 2023 (12+5) periods and for 2024 5 periods (corresponding to the month of May), this in order to have the data in a nuance and then perform time series analysis by matured year.
Do you have any posts about summary tables that you mention or something similar?
Thanks!
Best regards