Divide first column value to next column second row value

Hi hb ,

I think there should be a date column or an index column in your data model to determine the order of the values.

If there isn't, I suggest you to add an index in Power Query Editor.

Percentage = 
VAR _PREVIOUS23 = CALCULATE(SUM('Table'[Receivables Balance -23M]),FILTER(ALL('Table'),'Table'[Index] = EARLIER('Table'[Index]) - 1))
RETURN
DIVIDE(_PREVIOUS23,[Receivables Balance -24M])

Result is as below.

Best Regards,
Rico Zhou

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