Difference Calculation Error for Periods

[Anonymous]

Hi Experts

See Sample Data - I am trying to work out the diference month on month starting at M0

My Measure give me

M0 M1 M2 M3

202 10.1 29.3 55.2

the Step M0-M1 is correct, Then its doing M0-M2 as opposed to M1-M2, and M0-M3 as opposed to M2-M3....

My Dax Measures are

1. Paydown = [Value]*[Percentage] (where i am getting the Max for the value and Percentage column)

2. Balance Paydown =
VAR _prevdate = Lastnonblank(
Filter(All('Input'[M Column]), 'Input'[M Column]>= SelectedValue('Input'[M Column])
),
[Paydown])

Return

Calculate([Paydown],'Input'[M Column]<=_prevdate)

Then a New Measure

Bal = if([Maxcolumn] = "M0", [Paydown], [Balance Paydown]-[Paydown])

Expected Result PS Calculated Column well not work as this is a subset of a bigger picture with more products

[amitchandak · Accepted solution]

@Anonymous , Please find the attached file after signature