Forum Discussion
Helper IVTrend on Price
Hi,
I have a single table with Date, Product, and Price columns called PRODUCT table, Date goes back to 4 years
I need to find a way to Select Product using filters to compare pricing going back last 2 years. So Filter 1 selects Product A, and in Filter 2 Select Product B. I would like to see the price trend between those two prodcuts by month going back last two month.
Appreciate it.
Create two disconnected tables for your slicers, Table1 = VALUES('Table'[Product]) and Table2=VALUES('Table'[Product]). Then use MAX or SELECTEDVALUE in two measures to return Price of one or the other.
1 Reply
- Greg_Deckler
Community Champion
Create two disconnected tables for your slicers, Table1 = VALUES('Table'[Product]) and Table2=VALUES('Table'[Product]). Then use MAX or SELECTEDVALUE in two measures to return Price of one or the other.