Price Change Impact

[HarishRathore25]

Hi Team,

This is a an very urgent request, I am trying to analyze price change impact of my brand (Product 1) with competition brand (Product 2). I am attaching an excel data as I am working on PowerPivot data model. File has 2 sheets one is “Raw Data” and sheet 2 “Expected Result”. I tried a lot but I am not able to get desired results as I am getting sum of MRP while using pivot table. I have run out of options hence seeking your expertise. There are changes in MRP (basically pricing) in between months as well hence want to have view for both OLD price and new price as well. I am using power pivot data model hence requesting solution for the same. Need help with dax measure to solve this.

Sample data as follows;

Company YearYearMonthBrandPack SizeMRPVolume

2021-22	2021	Jul	Product 1	12x75	1000	531
2021-22	2021	Jul	Product 1	24x37.5	700	958
2021-22	2021	Jul	Product 1	48x18.0	350	1200
2021-22	2021	Aug	Product 1	12x75	1000	700
2021-22	2021	Aug	Product 1	24x37.5	700	1123
2021-22	2021	Aug	Product 1	48x18.0	350	1569
2021-22	2021	Aug	Product 1	12x75	1100	200
2021-22	2021	Aug	Product 1	24x37.5	800	500
2021-22	2021	Aug	Product 1	48x18.0	450	700
2021-22	2021	Sep	Product 1	12x75	1100	450
2021-22	2021	Sep	Product 1	24x37.5	800	655
2021-22	2021	Sep	Product 1	48x18.0	450	854
2021-22	2021	Jul	Product 2	12x75	1000	423
2021-22	2021	Jul	Product 2	24x37.5	700	759
2021-22	2021	Jul	Product 2	48x18.0	350	925
2021-22	2021	Aug	Product 2	12x75	1000	600
2021-22	2021	Aug	Product 2	24x37.5	700	900
2021-22	2021	Aug	Product 2	48x18.0	350	1325

Expected Results;

			Product 1						Product 2
			MRP	VOLUME	MRP	VOLUME
Company Year	Year	Month	12x75	24x37.5	48x18.0	12x75	24x37.5	48x18.0	12x75	24x37.5	48x18.0	12x75	24x37.5	48x18.0
2021-22	2021	Jul	1000	700	350	531	958	1200	1000	700	350	423	759	925
2021-22	2021	Aug	1000	700	350	700	1123	1569	1000	700	350	700	1123	1569
2021-22	2021	Aug	1100	800	450	200	500	700	1000	700	350	700	1123	1569
2021-22	2021	Sep	1100	800	450	450	655	854	0	0	0	0	0	0

Please help me in this regards.

Thanks
Harish Rathore

[v-robertq-msft · Accepted solution]

Hi, 

According to your description, I can roughly understand your requirement, I think you can try to achieve the expected output using the matrix visual in the Power BI:

This is the test data I created based on your description:

And you can create a matrix chart and place the columns like this to get what you want, like this:

You can download my test pbix file below

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You need to add a column to your data that indicates which price version it is. Without that you will not be able to tell which price is "old"  and which is "new".