How to Calculate Growth Rate in the Same Quarter Different Year?

[Anonymous]

Hi All,

I am pretty new for Power BI. I am wondering how can I calculate growth rate between 2019 Q1 and 2020 Q1? By the way, how Power BI can recognize my Q1-Q4 and Week 1-52 as a Date instead of Text?  Thanks in advance! 

Yr/Qtr	Week	Region	Sales
2019 Q1	1	NY	250
2019 Q1	2	TX	300
2019 Q1	3	CA	400
2020 Q1	1	NY	300
2020 Q1	2	TX	400
2020 Q1	3	CA	500

[Mariusz · Accepted solution]

Hi @Anonymous 

The attached file contains a solution that:

1. Converts the week column to Date in Query Editor.
2. Contains Additional Calendar Table ( Crucial for time intelligence functions  / best practice )

Contains a Measure that calculates Same Period Last Year ( you can use it to calculate growth )  :

Sales PY = 
CALCULATE( 
    [Sales],
    SAMEPERIODLASTYEAR( 'Calendar'[Date] )
)​

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn