Filtering data in one table based on data in another

[alearner]

Hi,

I am a newbie in Power BI and trying to learn. So need some help as t how to implement the below.

I have two tables which are connected with Product ID. One containing the sales of products for last 1 year and this keeps rolling and another historical table containing the list of Products unit price for the last 5 years.

I would like to create a line chart showing the Unit Price for only those 12 months for which I have sales and ignore the historical data. How can I achieve the same !!

[alearner]

Product ID	Product Name	Date	Unit Price
1	a	1/1/2020	10
1	a	2/1/2020	15
1	a	1/1/2022	30
1	a	2/1/2022	15
1	a	3/1/2022	20

Product ID	Date	Sales
1	1/1/2022	25
2	10/20/2022	30
3	11/31/2022	50
1	12/20/2022	100

Above are the two sample tables and ofcourse I have the Date table also. I would like to create the trend line for Unit Price by Product for the time frame for which I have sales and ignore any historical data. Like I have sales only for the year 2022 so would like to ignore the Unit Price for the year 2020. 

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[ribisht17]

@alearner 

Please share the sample tables here

Regards,

Ritesh