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.
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.
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 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |