Need help on matrix table visualization

[pixy816]

Hi,

I come across a case where I need to carry forward one of the field values to next month using matrix table visualization. I am not sure what functionality that i need to use to archieve this. This is the output result i done so far.

My expected outcome would be like this:

Any help would be greatly appreciated.

[edhans]

If I understand, you want "sales remainder" from last month to be combined with Target this month to get a new target.

It would be something along the lines of:

Revised Target =
[Target] + 
CALCULATE ( 
     [SalesRemainder],
     PREVIOUSMONTH ( Dates[Dates] ) 
)

[pixy816]

Thanks!