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...
| 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.
