Divide first column value to next column second row value

[hb]

HI All,

I need the following DAX , 

Divide first column value to next column second row value

current dax i am using 

Receivables Balance -23M % = DIVIDE([Receivables Balance -23M],[Receivables Balance -24M],0)

which is not producing the required result.

any help highly appreciated

Thanks 

[hb]

Thanks for your support.

actyually these both are measures.

[Receivables Balance -23M]

[Receivables Balance -24M]

Determine from the column [Receiable Balance] as below DAX

[Receivables Balance -23M] = CALCULATE ([Receivables Balance], DATEADD('Date'[Date], -23, MONTH))

[Receivables Balance -24M] = CALCULATE ([Receivables Balance], DATEADD('Date'[Date], -24, MONTH))

regards,

[Anonymous]

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.