Solved: Partly Cumulative Sum Measure in Matrix

vkisa · ‎10-29-2024

Hi,

I need some help to calculate cumulative sum in matrix.

I have income matrix by date1 and date2 columns as below.

Date2Month

And, there is also total cost by date1 as below,

Date2Month Cost

The matrix I want to reach out is as below.

Date2Month

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.

Here is how the matrix should be calculated as,

Date2Month

I can upload a sample pbix file if you need. Thank you for your helping.

Regards,

Veli

lbendlin · ‎10-29-2024

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

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

lbendlin · ‎10-29-2024

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

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

vkisa · ‎10-29-2024

Thank you @lbendlin , the measure works for me.

Partly Cumulative Sum Measure in Matrix