Forum Discussion

SakshiNijhawan's avatar
SakshiNijhawan
Frequent Visitor
5 years ago

Computing row-wise running/cumulative total in a matrix

Hi community members,   I am trying to calculate row-wise running total of principal balance in a matrix and then make a curve for the same. To achieve the same, for now, I have calculated 8 differ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

SakshiNijhawan , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

SakshiNijhawan's avatar
SakshiNijhawan
Frequent Visitor
5 years ago

Hi Amit,

Pleasse find the sample output table attached. I am looking to find a row-wise cumulative total of principal balance for each month. Further, I am looking to do a sumproduct of the principal balance with each column value/category and divide the sumproduct by the sum of the principal balance. The formula is mentioned in the image for your reference.

 

These calculated values using sumproduct are the ones that I need to use for my curve that I mentioned in my post.

 

Let me know if you have any more questions.

 

Thanks,

Sakshi