cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aditidhooria Frequent Visitor
Frequent Visitor

transpose

Hi everyone,

 

I have a column C1 for table sample table. I am trying to plot a table in which I need to use the fields as columns in my table and display count of fileds in respective positions. 

 

For example: I have a the following table:

 

q1.PNGRequired Table

And the output should look like the following ie. E1, E2 and E3 have counts in their field values :

 

q2.PNGOutput

 

Can anyone help ?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: transpose

That's actually a Pivot-operation: http://radacad.com/pivot-and-unpivot-with-power-bi

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




1 REPLY 1
Super User
Super User

Re: transpose

That's actually a Pivot-operation: http://radacad.com/pivot-and-unpivot-with-power-bi

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries