Forum Discussion

hb's avatar
hb
Frequent Visitor
3 years ago

Divide first column value to next column second row value

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],[Receiv...
Need Help
hb's avatar
hb
Frequent Visitor
3 years ago

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,