Forum Discussion
Remove Duplicates
Hi,
I want to remove duplicates in Power BI Data tab. I have created a new column and I want to remove duplicates. How I can do that.
We can do it using tranform table but I created a new column in data tab so that column is not appearing in transform tab.
Also, Can i create concatenate in transform table? I want to add text and num value. Its giving an error we cannot combine text and value in tarnsform concatenate.
Thnaks
C
Hi,
This M code should let you comobine text with number
=Text_column&Number.ToText(Numeric_column)
Replace Text_column and Numeric_column with your actua table and column names.
17 Replies
I know how to remove duplicates in transform tab.
I want to remove duplicates in data tab. How can I do that?
Or is there any way that we can add two columns in transform tab whic is one column is text other column is value.
Hi,
You should first remove duplicates in the Query Editor and then create your new column.
I know but I want to create a new column using my post code and state. Then I want to remove the duplicates. In transform tab I cannot combine state and postcode together because one is text value and other one is number value.
How can I combine those two columns in tranform tab?
Hi,
This M code should let you comobine text with number
=Text_column&Number.ToText(Numeric_column)
Replace Text_column and Numeric_column with your actua table and column names.
