Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |