percentage differnce in power bi

[Anonymous]

Hi all,

      I tried to find percenatge differnce with the two values...its calcualtion perfectly done in power bi .Here am adding data exported from power bi for reference...

1st image is data for calcualtion...ie...here am taking two month  average rate for comparison...So...March2020 with April2020 by formula as

Rate change value=(New value-old value)/old value

 is getting...correctly...But now i am facing here an issue.

2nd image Monthly june 2021 is coming which is not needed and not in the listed in 1st image ...So..Is there any solution for removing june 2021 from the list?plse help..

steps i used are

Average rate=average(values)

Previous Month = CALCULATE ( [Average rate], DATEADD ( 'Calendar'[Date], -1, MONTH ) )

Rate Change =

IF (

NOT ISBLANK ( [Previous Month]),

DIVIDE (

[Average rate] - [Previous Month],

[Previous Month]

)

)

[amitchandak · Accepted solution]

@Anonymous , Try like

Rate Change =
if(isblank([Average rate]), blank(),
IF (
NOT ISBLANK ( [Previous Month]),
DIVIDE (
[Average rate] - [Previous Month],
[Previous Month]
)
))