Forum Discussion
Filtering data in one table based on data in another
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 !!
3 Replies
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.
