Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous , You will need one/two independent product table
refer how this done for dates/period
@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])
Hi @amitchandak ,
Would it be possible to make Product dynamic? Instead of typing "Prod 1"? I do have a unique key for every line.
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!
@Anonymous , You will need one/two independent product table
refer how this done for dates/period
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
77 | |
67 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |