Forum Discussion
Cumulative Sum Table
- 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.
Hi Syndicate_Admin ,
I've prepared your required output for 2023 which includes 5 months of 2024, but putting 2024 month 01 to 05 side by side will require some effort, as it is duplicate information of periods 13 - 17 in 2023, and inbuilt Power BI relationship logic prevents duplicate counting by ensuring many to one relationship and do not recomment many to many relationship, presicely for this reason of preventing duplicate counting. I attach pbix file for your reference.
Best regards,