Forum Discussion
Remove Duplicate rows by getting value in separate columns
Hi , I am new to Power BI and trying to remove duplicates. Can anyone please help me with this? This is what i have And trying to get it like below. Thanks for your time
Erokor
Resolver II
Resolver IIIf you select the little carrot to the right of the "Count of Status" you can then adjust that to "First" or last. Since you only have the value once for each number in the header it would show 1 for 1.
This is really a hacky way to do it. The better way would be to model your data properly up front (using Transpose as I mentioned before).
Got it . i tried the other way also
- Erokor
Great! If my solution helped you to achieve the result you are looking for, please select it as a solution to help others find the help they might need in this instance!