Create a cumulative table over the years

Question

Hello,&nbsp;&nbsp;I have a very specific question:&nbsp;I have a datatable for 2020 and values that I want to be repeating fo the coming years&nbsp;For now I have only the grey table for 2020, and I want to create the whole table for the next 5 yearsBut I also need to consider (for exemple saying 2022) the figures from 2020 and 2021So I want to create inside Power Query (Or Power BI Desktop) the Cumulative Column: Once a value is added, it will be repeated every year at the same date but it will be taking into account the new values (in orange and yellow)&nbsp;&nbsp;I hope I was clear enough,&nbsp;Thanks in advance,&nbsp;Constance

edhans · Answer

I think you are going to have to give a bit more info. I cannot tell how all of the non-gray data was created. Please see instructions below.
How to get good help fast. Help us help you.How To Ask A Technical Question If you Really Want An AnswerHow to Get Your Question Answered Quickly - Give us a good and concise explanationHow to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

Forum Discussion

Create a cumulative table over the years

1 Reply

Related content

Creating Cumulative Graphs

Create new table

Lakehouse Table Generate Create Table

Cumulative Total

Create rows from 2 tables