Cumulative total across a row

Question

Hi All;&nbsp;Relatively new to PowerBI here, and struggling....I am trying to show a cumulative cash flow over time across a row. I see many options for cumulative totals down a column, but I need a row:Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Jan &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feb &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; MarProject 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5Project 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; -3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6Total &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 11Cumulative &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 35 &lt;---- How do I create this row??&nbsp;I am hopeful, but my optimism is waning.... &nbsp; &nbsp;

dax · Accepted Answer

Hi wsmaguire,
You could change data structure by M code and add a Total row in it, then use measure to calculate cumulative value. You could refer to my sample for details.
Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Cumulative total across a row

2 Replies

Related content

Cumulative Total

Cumulative Total

SumX? - cumulative running total

Cumulative Total

Cumulative total