Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
And the output should look like the following ie. E1, E2 and E3 have counts in their field values :
Can anyone help ?
Solved! Go to Solution.
That's actually a Pivot-operation: http://radacad.com/pivot-and-unpivot-with-power-bi
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
That's actually a Pivot-operation: http://radacad.com/pivot-and-unpivot-with-power-bi
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |