Can you minus rows in a matrix visualisation?

[Anonymous]

Hi All,

Based on a dataset with 3 pivoted columns "Product", "date", "price" I created the following matrix. Both product 1 and product 2 (and others) have multiple rows in the imported dataset. So are not unique values. They are registered per sale. I created a matrix by putting product in the row, date in the columns and price in the values. This is exactly what I wanted to see. However, I also would like to see the result of prod 1 minus prod 2 for each month. If it is not possible in the matrix below I don't mind creating an extra one just for this. But I have no idea how to do this since the prices and product names are in the same column. This means a measure like AVERAGE(table[price]) - AVERAGE(table[price]) will not work, as this results in all 0's. 

So how can I see the result of prod 1 minus prod 2 for each month? 

Kind regards,

commodity_check

[amitchandak]

@Anonymous , You have to try a measure like

AVERAGEX(filter(allselected(Table[product]) ,Table[product] = "Prod 1") ,table[price]) - AVERAGEX(filter(allselected(Table[product]) ,Table[product] = "Prod 1") ,table[price])

[Anonymous]

Hi @amitchandak ,

Would it be possible to make Product dynamic? Instead of typing "Prod 1"? I do have a unique key for every line. 

[v-kelly-msft]

Hi @Anonymous ,

Could you pls provide your expected output in details?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak · Accepted solution]

@Anonymous , You will need one/two independent product table 

refer how this done for dates/period 

https://youtu.be/44fGGmg9fHI