Partly Cumulative Sum Measure in Matrix

Question

Hi,&nbsp;I need some help to calculate cumulative sum in matrix.I have income matrix by date1 and date2 columns as below.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date2Month &nbsp; &nbsp; &nbsp; &nbsp;Date1YearDate1MonthFebruaryMarchAprilMayJune2024February61-238670132024March&nbsp;81704552024April&nbsp;&nbsp;9159422024May&nbsp;&nbsp;&nbsp;99782024June&nbsp;&nbsp;&nbsp;&nbsp;170&nbsp;And, there is also total cost by date1 as below,Date2Month CostFebruary632March83April128May181June217&nbsp;The matrix I want to reach out is as below.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date2Month &nbsp; &nbsp; &nbsp; &nbsp;Date1YearDate1MonthFebruaryMarchAprilMayJune2024February-571-594-508-438-4242024March&nbsp;-2681131482024April&nbsp;&nbsp;-3722642024May&nbsp;&nbsp;&nbsp;-82-42024June&nbsp;&nbsp;&nbsp;&nbsp;-47&nbsp;And the calculation of aim matrix;1- Income- Cost for diagonal cells (Feb-Feb, March-March,...)2- For next months the calculation should be aggregated sum.&nbsp;Here is how the matrix should be calculated as,&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date2Month &nbsp; &nbsp; &nbsp; &nbsp;Date1YearDate1MonthFebruaryMarchAprilMayJune2024February"61-632=-571""-571-23""-594+86""-508+70""-438+13"2024March&nbsp;"81-83""-2+70""68+45""113+35"2024April&nbsp;&nbsp;"91-128""-37+59""22+42"2024May&nbsp;&nbsp;&nbsp;"99-181""-82+78"2024June&nbsp;&nbsp;&nbsp;&nbsp;"170-217"&nbsp;I can upload a sample pbix file if you need. Thank you for your helping.&nbsp;Regards,Veli&nbsp;

lbendlin · Accepted Answer

This is one of the rare cases where a bidirectional relationship makes some sense.
&nbsp;

&nbsp;
I assumed your data is in a much better shape, like this
&nbsp;

&nbsp;
&nbsp;

Forum Discussion

Partly Cumulative Sum Measure in Matrix

2 Replies

Related content

Cumulative Difference from Another measure

Cumulative Measure

Cumulative Total

Transform measure in cumulative measure

Cumulative measure / 100

Date1Year	Date1Month	February	March	April	May	June
2024	February	61	-23	86	70	13
2024	March		81	70	45	5
2024	April			91	59	42
2024	May				99	78
2024	June					170