Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
hi @Marshmallow
Check this measure
after changing date filter Number is still constant.
I hope I answered your question!
Hi @Marshmallow
You can write it without Filter().
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.
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.
hi @Marshmallow
Check this measure
after changing date filter Number is still constant.
I hope I answered your question!
hi @Marshmallow
Check this measure
after changing date filter Number is still constant.
I hope I answered your question!
Hi @Marshmallow
You can write it without Filter().
Thank you, it works!! 😊
User | Count |
---|---|
120 | |
72 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |