Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI all,
I am quite new to power bi and I have the following questoin:
I have a tabel (Cases) with different columns and I would like to make a report (table PresentCases) with, among others, two columns with information with information based on the same column in the origanal tabel. Like this.
Data:
Table Cases
Casenumber | partyname | Partyrol |
1 | George | 1 |
1 | Pete | 2 |
2 | John | 1 |
2 | Carlos | 2 |
3 | Silvia | 1 |
3 | Gregory | 2 |
From this data I would like to have a report with the following columns:
Report PresentCases
Casenumber | Partyrol 1 | Partyrol 2 |
1 | George | Pete |
2 | John | Carlos |
3 | Silvia | Gregory |
How do I get these two columns, out of one?
If you just want to display that table in the report, I guess you could just create an array. Remember to turn off totals.
Paul Zheng _ Community Support Team
If this post helps, please accept it as the solution to help the other members find it faster.
Hi Vanessa,
I think your solution might work, however, I am not able to pivot the table. I get an Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=[Type]
User | Count |
---|---|
140 | |
113 | |
104 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |