Forum Discussion

jonclay's avatar
jonclay
Icon for Helper IV rankHelper IV
2 years ago
Solved

Working out the %age increase / decrease year on year

Hi everyone I'm trying to work out the percentage increase or decrease based on year on year values within a table. I'm using this DAX Measure to calculate the value of payments from each conta...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jonclay ,

     

    Thanks divyed  for the quick reply. I have some other thoughts to add:

    (1) We can create measures.

    rank =
RANKX (
    SUMMARIZE ( ALLSELECTED ( 'Fin_Yr' ), [Fiscal Year], "nett", [Paid (Nett)] ),
    [Fiscal Year],
    MAX ( 'Fin_Yr'[Fiscal Year] )
)

    Change = var _rank=[rank]+1
var _pre= CALCULATE([Paid (Nett)],FILTER(ALLSELECTED('values'),[rank]=_rank))
var _current=[Paid (Nett)]
RETURN DIVIDE(_current-_pre,_pre)

    (2) Then the result is as follows.

     

    Best Regards,

    Neeko Tang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jonclay ,

 

Thanks divyed  for the quick reply. I have some other thoughts to add:

(1) We can create measures.

rank =
RANKX (
    SUMMARIZE ( ALLSELECTED ( 'Fin_Yr' ), [Fiscal Year], "nett", [Paid (Nett)] ),
    [Fiscal Year],
    MAX ( 'Fin_Yr'[Fiscal Year] )
)

Change = var _rank=[rank]+1
var _pre= CALCULATE([Paid (Nett)],FILTER(ALLSELECTED('values'),[rank]=_rank))
var _current=[Paid (Nett)]
RETURN DIVIDE(_current-_pre,_pre)

(2) Then the result is as follows.

 

Best Regards,

Neeko Tang

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