Forum Discussion

CCVCC-R's avatar
CCVCC-R
New Member
3 years ago

Calculating YoY Growth

Hi Guys,

 

I'm currently stuck on trying to create a solution on YoY Growth. 

 

Essentially, I have a current year revenue number, and I want to build a table/matrix where it will show YoY Growth based on a slider in Power BI by year. See screenshot below. 

 

 

Currently, in power BI, I have multiple measures where I take the $500, and multiply it by a growth percentage to get the Next FY number. However, by doing it this method, I have trouble showing it has multiple year growth.

 

Any assistance will be appreciated, thank you!

 

Need Help
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    CCVCC-R , if you have date with help from date table last year data

     

    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
    Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

     

     

    Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
    Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
    Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s