topic Divide first column value to next column second row value in Developer

Divide first column value to next column second row value

hb — Wed, 10 May 2023 09:38:10 GMT

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

Re: Divide first column value to next column second row value

Anonymous — Fri, 12 May 2023 03:15:24 GMT

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.

Re: Divide first column value to next column second row value

hb — Sat, 13 May 2023 06:56:17 GMT

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,