cancel
Showing results for
Did you mean:
Highlighted Helper I

## Year Over Year Percentage Calculation not working

Hi There,

I am trying to do a Year over Year calculation in power BI for the following data

 Period Total Production Variance Financial Year Identifier 12/31/2014 70 Prior Period 2 12/31/2015 90 Prior Period 12/31/2016 100 Current Period

can you help me get he year over year calc - current year - prior period /prior period  and current period - Prior period 2 / prior period 2

without hardcoding the values ??

I tried the quick measures it doesn't work in my table/

I also tried doing this myself it doesnt work

SumVariance = CALCULATE(SUM('Inventory Summary Data'[Total Production Variance]))

VarianceLastYear = Calculate(SUM('Inventory Summary Data'[Total Production Variance]) ,SAMEPERIODLASTYEAR('Inventory Summary Data'[Period].[Date]))

YoYVariance = if(SELECTEDVALUE('Inventory Summary Data'[Financial Year Identifier]) = "Current Period",[SumVariance]/[VarianceLastYear]-1)

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted Community Support

## Re: Year Over Year Percentage Calculation not working

Hi @motyagi,

Based on my test, we can get the values as you want the following steps.

1. Enter the data as you shared and create the measure as below:

`VarianceLastYear = Calculate(SUM('Inventory Summary Data'[Total Production Variance]) ,SAMEPERIODLASTYEAR('Inventory Summary Data'[Period]))`
`VarianceLast2Year = TOTALYTD(SUM('Inventory Summary Data'[Total Production Variance]),DATEADD('Inventory Summary Data'[Period],-2,YEAR))`
```YoYVariance = var
P =SELECTEDVALUE('Inventory Summary Data'[Financial Year Identifier])
return
IF(P = "Current Period",[SumVariance]/[VarianceLastYear]-1)```
```YoYVariance2 = var
P =SELECTEDVALUE('Inventory Summary Data'[Financial Year Identifier])
return
IF(P = "Current Period",[SumVariance]/[VarianceLast2Year]-1)```

2. Then we can get the result as below. For more details, please check the pbix as attached.

https://www.dropbox.com/s/7n2b4u2sb7cd49m/Year%20Over%20Year%20Percentage%20Calculation%20not%20work...

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
2 REPLIES 2
Highlighted Community Support

## Re: Year Over Year Percentage Calculation not working

Hi @motyagi,

Based on my test, we can get the values as you want the following steps.

1. Enter the data as you shared and create the measure as below:

`VarianceLastYear = Calculate(SUM('Inventory Summary Data'[Total Production Variance]) ,SAMEPERIODLASTYEAR('Inventory Summary Data'[Period]))`
`VarianceLast2Year = TOTALYTD(SUM('Inventory Summary Data'[Total Production Variance]),DATEADD('Inventory Summary Data'[Period],-2,YEAR))`
```YoYVariance = var
P =SELECTEDVALUE('Inventory Summary Data'[Financial Year Identifier])
return
IF(P = "Current Period",[SumVariance]/[VarianceLastYear]-1)```
```YoYVariance2 = var
P =SELECTEDVALUE('Inventory Summary Data'[Financial Year Identifier])
return
IF(P = "Current Period",[SumVariance]/[VarianceLast2Year]-1)```

2. Then we can get the result as below. For more details, please check the pbix as attached.

https://www.dropbox.com/s/7n2b4u2sb7cd49m/Year%20Over%20Year%20Percentage%20Calculation%20not%20work...

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted Helper I

## Re: Year Over Year Percentage Calculation not working

Thanks ! this works great 🙂

Announcements #### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members. #### Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start. #### Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries! #### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications Top Solution Authors
Top Kudoed Authors
Users online (1,549)