Forum Discussion
Transpose table with weighted average
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
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.
Select four column and click Unpivot
Now this is your Table
This is Matrix Report
4 Replies
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.
Select four column and click Unpivot
Now this is your Table
This is Matrix Report
Hello Baskar. Thank you for your sugestion. I will look at this once I will be back from my holiday.
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-values-on-rows-instead-of-colum
Hello ImkeF. Thank you for your sugestion. I will look at this once I will be back from my holiday.
