Forum Discussion

PFinnegan's avatar
PFinnegan
Regular Visitor
4 years ago

Moving data value up and across

Looking for some help on a calculation I'm trying to create on this report I'm looking to build. I've reached out for support and tried a few things but just can't work out how to do this. So I hav...
v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi PFinnegan ,

 

Assume that the column field in the matrix table is [number], then use the following formula to move the rows.

 

Total Cash Month on Month Adjustment (test) =
VAR EarlierTime =
    CALCULATE (
        MAX ( View_D_DynamicAgeing[Month] ),
        FILTER (
            ALLSELECTED ( View_D_DynamicAgeing[Month] ),
 
            View_D_DynamicAgeing[Month] <
            ( SELECTEDVALUE ( View_D_DynamicAgeing[Month] ) + VALUE ( SELECTEDVALUE ( 'View_D_DynamicAgeing'[number] ) ) - 1)
        )
    )
VAR EarlierMeasureValue =
    CALCULATE ( [Total Cash] , View_D_DynamicAgeing[Month] = EarlierTime )
RETURN

 

  CALCULATE(
  Measure_Table[Total Cash] -
  EarlierMeasureValue)

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.