Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Guys,
Can you please help me with transposing table?
I need to create P&L per specific category.
My problem is that Category is in rows but I need that in columns.
Please be aware that current % are not averages but weighted average calculated as measures.
(DAX formula : SUMX('Test',Test'[Total amount]*Test[New ROA])/SUM('Test'[Total amount])
In best case scenario I would include there as well figures (these can be sums)
Many thanks in advance.
Andrej
Solved! Go to Solution.
Hi,
I tried but i can't any way to get table like which u mention in above.
but i suggested to u, y u go with like this model. it will also help to u reach your goal.
pls look these images , and let me know if any help.
Here you find a nifty workaround for your request: http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
... and of course: Pls vote for this to become a standard-feature here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-value...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hello ImkeF. Thank you for your sugestion. I will look at this once I will be back from my holiday.
Hi,
I tried but i can't any way to get table like which u mention in above.
but i suggested to u, y u go with like this model. it will also help to u reach your goal.
pls look these images , and let me know if any help.
Hello Baskar. Thank you for your sugestion. I will look at this once I will be back from my holiday.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |