growth formula for new mesure

[rjunai200]

in excel i have the calculated feild as:

=IFERROR(('Current Year'/'Prior Year')-1,0)

and in power bi i have the mesure as:

Growth % = DIVIDE(SUM(PivotData[Current Year]), SUM(PivotData[Prior Year])-1)

but for some reason i am not getting the same number for growth with my excel calculated field (which i am trying to replicate) and this formula?

and the grand total is showing 3.1% in excel and its showing 63% in total on power bi,

[konstantinos]

 @rjunai200 Is difficult if we don't have the underlying numders.

Usually growth is in the format of 

Growth % =
DIVIDE (
SUM ( PivotData[Current Year] ) - SUM ( PivotData[Prior Year] ),
SUM ( PivotData[Prior Year] )
)

since DAX is using columns and not cells.

or add a bracket where you need the substaction 

DIVIDE (
SUM ( PivotData[Current Year] ) ,
(SUM ( PivotData[Prior Year] ) - 1)
)

or if these are two column of the same table

AVERAGEX ( PivotData,

DIVIDE (
SUM ( PivotData[Current Year] ) ,
(SUM ( PivotData[Prior Year] ) - 1)
))

or instead of AVERAGEX() use SUMX()

[rjunai200]

hi it did not work for some reason my data is set up like this

client 1  jan    555 (current yearrevenue)          666 ( prior year revenue)

client 1  feb    545 (current yearrevenue)          662 ( prior year revenue)

.....

client 2        jan

client 2        feb

[konstantinos]

it works in my end