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...
Need Help
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] ) 
)
pixy816's avatar
pixy816
Regular Visitor
7 years ago

Thanks!