Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 other than "X" then the Status should be Complete, if there is atleast one record wiith "X" then the Status should be Cancelled. If, I can transform the table like the below, I can able to get the status column used in my further actions.
Can anyone hlep, please
Regards
Kals
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
127 | |
109 | |
93 | |
70 | |
67 |