Forum Discussion
YOY Growth
Hi,
I have successfully managed to plot the year on year growth as shown below. However, how do I get rid of the 100% in the 2019 column under the YOY and variance?
Also r, if I select a particular year say 2020, it is not showing the revenue PY from 2019. Is there a way to fix this? My current fix is to select both 2019 and 2020 to show 2019 number.
10 Replies
HI Anonymous ,
Please use the following approach:
Revenue_YoY Variance = var var_RevenueCurrentYear = [Revenue_Total] var var_RevenuePreviousYear = [Revenue_PY] RETURN IF( ISBLANK(var_RevenuePreviousYear), BLANK(), DIVIDE(var_RevenueCurrentYear,var_RevenuePreviousYear) - 1 )Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Anonymous
Can you plese also show your PY measure so that I can help you solving the second issue?
Best regards
Michael
Hi Mikelytics thanks for the quick reply. Let me try your first solution out. In the meantime this is formula used for the PY:
Revenue_PY = CALCULATE([Revenue_Total],DATEADD('Product Pivot'[Date].[Date],-1,YEAR))
Anonymous
sorry I think it was a misunderstandin. THe measure I sent you was meant to be used as your percentage measure 🙂
so please do your Revenue_YoY variance mwasure as it was and then please replace the fomrula for the measure Revenue_YoY variance %
Revenue_YoY Variance % = var var_RevenueCurrentYear = [Revenue_Total] var var_RevenuePreviousYear = [Revenue_PY] RETURN IF( ISBLANK(var_RevenuePreviousYear), BLANK(), DIVIDE(var_RevenueCurrentYear,var_RevenuePreviousYear) - 1 )Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
