Percentage of average price diff same period last year but for matching items/products only.

[Anonymous]

Hi,

Actully I'm craeting a KPI . 
Calculate Average price diffrence (Period to Same Period before/last year) :
Taking average of products in the date range and same range last year but matching proucts only. Basically a Inner join of product (selected period products inner join with same period last year products)

For ex: From below image if user has selected date rage of 01-Feb-2021 to 05-Jun-2021, then prod(A,B,C,D)Average will be 66.75, but for same period in last year product D is not present then we want to exclude tht product from avg cal. so, new avg will be prod(A,B,C) 61.66 and same period last year  prod(A,B,C) avg is 45. and diffrence will 61.66-45.

Name	Department	Value	Product	Year	Date(DD-MM-YYYY)
Alex	Tech	99	A	2021	01-02-2021
Scott	Disp	47	B	2021	10-02-2021
Ray	Tech	39	A	2021	10-02-2021
Joy	Disp	82	D	2021	04-06-2021
Alex	Tech	27	A	2020	01-02-2020
Alex	Tech	53	B	2020	10-02-2020
Alex	Tech	55	B	2020	15-02-2020

 Hlp me resolving this issues. Thanks in advance .

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picuture and the attached pbix file.

All measures are in the attached pbix file.

[Anonymous]

Thank you for quick help.