Forum Discussion

pixy816's avatar
pixy816
Regular Visitor
7 years ago

Need help on matrix table visualization

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.

Need Help

2 Replies

  • edhans's avatar
    edhans
    Community Champion
    7 years ago

    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] ) 
)