Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AndrejZitnay
Post Patron
Post Patron

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
Baskar
Resident Rockstar
Resident Rockstar

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
ImkeF
Super User
Super User

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.

Baskar
Resident Rockstar
Resident Rockstar

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

 

 

 

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.