Current row value should get added to the previous column grand total in power bi

Srini Mysore 1 Reputation point
2022-09-03T17:23:12.383+00:00

----------

Hi, I want to write a measure to add a value of a specific row value to the grand total of previous column value.
For e.g. As shown in the attached picture containing a matrix. I have a row with a value "Project: Engineering Forecast - CRP" containing values 0, 12, 10 , 11, 6 for the month "9/1/2022", "10/1/2022", "11/1/2022", "12/1/2022" respectively. I want to add

  1. the value "12" to the total value "181" ( 181+12=193).
  2. Add "10" to the total "193" ( 193 + 10 =203)
  3. Add "11" to the total "203" ( 203 + 11 =214)
  4. Add "6" to the total "214" ( 214 + 6 =220)

I want a measure which can accomplish this. Please do the needful.

Default matrix grand total is not showing properly.

Thanks in advance,
Srini
237487-screenshot-2022-09-03-225517.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,748 questions
0 comments No comments
{count} votes