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
I tried the matrix visual , and it shows me this
I added "status" in values portion of visuals - but it changes to count of status .And shows like
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