Like for Like price monitoring

[pricing_ppg]

Hi !

I'm trying to do some like for like analysis about prices. I'ld like to calculate over two similar periods the "pure" price effect, that is the change of price only calculated for customers that have bought the same product during the two period.

Ex :

order number	date	product ID	Customer ID	Volume	Revenue	Price
1	01/01/2018	A	Eric	110	12	9,17
2	11/03/2018	B	Julien	116	14	8,29
3	02/06/2018	B	Pierre	115	11	10,45
4	08/07/2018	A	Nathan	111	15	7,40
5	22/02/2019	A	Julien	120	13	9,23
6	07/03/2019	B	Pierre	102	12	8,50
7	06/10/2019	A	Nathan	108	15	7,20
8	31/12/2019	B	Eric	106	10	10,60
	Average Price			like for like price
	2018	8,69		2018	8,69
	2019	8,72		2019	7,78
		0%		evo%	-11%

Here, the calculation I want is "evo% = -11%" which is the price effect between 2018 and 2019 only calculated for couples "customer + product" that exists in 2018 and 2019.

I was a qlik user and know how to write it for  qlikview... But I'm transfering all my reports to Power BI and try to replicate this analysis.

Any idea 🙂 ?

JC

[technolog]

Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.

If not, it may make sense to ask the question again, thus confirming the relevance of this problem.