Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a matrix that shows me the sales for each week.
Now I would like to add a second column that shows me the best week/ the highest sales.
But how?
Hi @joshua1990 ,
The highest sales:
MAXX(FILTER(ALL(Table),[week]=SELECTEDVALUE([week])),[sales each week])
The best week:
CALCULATE(MAX([week]),FILTER(ALL(Table),[sales each week]=[highest sales]))
If I misunderstand your meaning, please show some sample data and expected result to us.
Best Regards,
Jay
Some example data and expected results would make this much easier to answer.
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |