Forum Discussion
Pivot columns using grouping another column
Hi, I need your help in the below scenario, not sure if there is a possibility to achieve this in PBI. Here is my table; I have to group by Batch and Check the Code, if the code oth...
Hi kalyani,
By my tests, I'm afraid that we may not achieve your desired output based on your original table strature in Power BI .
As the workaround, you could create the matrix like below.
Best Regards,
Cherry
Hi Cherry, Thank you for your response. Yeah, even I tried creating the matrix, but the table we are trying to create can be used as a input for subsequent analysis and charts.. So, matrix won't help in this case.
Regards
Kals