Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I'm working on a matrix about product prices and their difference with the previous month, so far I managed with no problem to get this matrix:
Month | 1 | 2 | 3 | 4 | |||||||
Customer | Origin | Brand | Product | Price | Diff | Price | Diff | Price | Diff | Price | Diff |
A | A | A | Product1 | 10 | 0% | 10 | 0% | 12 | 20% | 12.6 | 5% |
A | A | Product2 | 5 | 1% | 6 | 20% | 6 | 0% | 9 | 50% |
In this, the month is the column, and the Price and Diff are the values.
The problem is that my boss wants something a little different, but I cannot find a way to do it.
Does anyone have any suggestions?
My boss wants to be like this:
Month | Price | Diff | |||||||||
Customer | Origin | Brand | Product | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 |
A | A | A | Product1 | 10 | 10 | 12 | 12.6 | 0% | 0% | 20% | 5% |
A | A | Product2 | 5 | 6 | 6 | 9 | 1% | 20% | 0% | 50% |
Solved! Go to Solution.
You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.
You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.
Thank you, that solved my problem!!
Regards,
This can be done but it will be painful and a lot of work.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |