cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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)

 

Transpose weighted average.JPG

 

Many thanks in advance.

 

Andrej

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Transpose table with weighted average

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 UnpivotSelect four column and click Unpivot

 

 

Now this is your TableNow this is your Table

 

 

This is Matrix ReportThis is Matrix Report

 

 

 

 

View solution in original post

4 REPLIES 4
Highlighted
Resident Rockstar
Resident Rockstar

Re: Transpose table with weighted average

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 UnpivotSelect four column and click Unpivot

 

 

Now this is your TableNow this is your Table

 

 

This is Matrix ReportThis is Matrix Report

 

 

 

 

View solution in original post

Super User IV
Super User IV

Re: Transpose table with weighted average

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

Highlighted
Helper V
Helper V

Re: Transpose table with weighted average

Hello ImkeF. Thank you for your sugestion. I will look at this once I will be back from my holiday.

Highlighted
Helper V
Helper V

Re: Transpose table with weighted average

Hello Baskar. Thank you for your sugestion. I will look at this once I will be back from my holiday.

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors