YOY growth on a particular period when another period is selected

[Marshmallow]

Hi,

I am trying to do sum of a category of a certain period when another period is selected. So I have a date table. below is a sample table

Product	April 2022	September 2024	November 2024
Food      - Noodle      - Rice	519 254 265	719 617 127	679 579 100
Footwear     - Shoes     - Thong	890 600 290	900 600 300	750 350 400
Other     - Misclenaous     - Shirt	600 350 250	808 408 400	900 200 700

I am trying to do YOY Growth in each product category since Apr 22 for each category including when other period is selected (e.g. Sept 2024, Nov 2024 and so on as more periods are added).

So the result for November 2024 would be:

Food - YOY Growth since Apr 22 is --> 30%

Footwear - YOY Growth since Apr 22 is --> -16%

Other - YOY Growth since Apr 22 is --> 33%

And the YOY growth since Apr will change based on any filters are selected, e.g. period, product category.

Can someone please help as I jsut cant seem to get the last bit correct?

[Uzi2019 · Accepted solution]

hi @Marshmallow 

Check this measure

Measure for April = CALCULATE(SUM(Lumix[Clicks]),FILTER(ALL('Calendar'),MONTH('Calendar'[Date])=4 && YEAR('Calendar'[Date])=2022))

after changing date filter Number is still constant.

I hope I answered your question!

[Uzi2019]

Hi @Marshmallow 

Still your query is not clear. please provide proper expected output in a form of table what do you want to campare and with sample number. 

use excel data or screenshot for better representing.

It helps other users to answer you question faster.

[Marshmallow]

Hi there

below is the screenshot of the sample

As you can see, when the PERIOD filter is not selected (PERIOD: ALL), the total Measure 2 is 10,579 - which is the total for April 2022 which is the result what I want regardless of any PERIOD selected.

At the moment, if I change PERIOD to September 2024, the Measure 2 becomes Blank instead of staying as 10,579.

I need a calculation where Measure 2 remains as the Total for April 2022 regardless of the filters being selected.

Hopefully this makes it more clearer and someone can help me.

[Uzi2019 · Accepted solution]

hi @Marshmallow 

Check this measure

Measure for April = CALCULATE(SUM(Lumix[Clicks]),FILTER(ALL('Calendar'),MONTH('Calendar'[Date])=4 && YEAR('Calendar'[Date])=2022))

after changing date filter Number is still constant.

I hope I answered your question!

[Uzi2019]

hi @Marshmallow 

Check this measure

Measure for April = CALCULATE(SUM(Lumix[Clicks]),FILTER(ALL('Calendar'),MONTH('Calendar'[Date])=4 && YEAR('Calendar'[Date])=2022))

after changing date filter Number is still constant.

I hope I answered your question!

[Uzi2019 · Accepted solution]

Hi @Marshmallow 

You can write it without Filter().

Measure for April = CALCULATE(SUM('Sales'),MONTH('Calendar'[Date])=4&& YEAR('Calendar'[Date])=2022)

Try this also... you may get the same result.

I hope I answered your question!

[Marshmallow]

Thank you, it works!! 😊