Bar chart of YoY percent change calculated from monthly percentages

[OAM]

I have the following data in Tab1:

Month	K_Penetration
2021-02	31%
2021-03	29%
2021-04	28%
2022-02	42%
2022-03	42%
2022-04	41%

And I also have a Calendar table which contains all the months in my Tab1.

I want to graph the YoY percentage change, to show how much growth there's been between 2021 and 2022 monthly. 

So the output should be a graph based on this table, using the formula per month, eg. for April --> (CurYear - PrevYear) / PrevYear:

Month	YoY % Change
02	0.35%
03	0.44%
04	0.46%

[SpartaBI · Accepted solution]

@OAM missing some info about your model.
Do you have a proper date table or just a table with the months you showed from Tab1.
Is your month a text column or a date formatted as month?
Anyway, I created this dim table (it's not really a calendar, but maybe that is what you have):
In my case the month was a date so it got the 1st of every month:

Then, I connected it to tab 1 like this: Calendar[Date] -> Tab1[Month]

Then, created this measure:

YOY % Change = 
VAR _current_year = CALCULATE(SUM(Tab1[K_Penetration]),'Calendar'[Year] = 2022)
VAR _prev_year = CALCULATE(SUM(Tab1[K_Penetration]),'Calendar'[Year] = 2021)
VAR _result = 
    DIVIDE(_current_year, _prev_year ) - 1
RETURN
    _result

And got this:

Showcase Report – Contoso By SpartaBI

      

[OAM]

Yes this is exactly what I wanted - it worked great! Thanks!!

[SpartaBI]

@OAMmy pleasure 🙂
Hey, check out my showcase report:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up if you liked it 🙂