Forum Discussion

cham's avatar
cham
Post Patron
6 years ago
Solved

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 col...
Data Protection
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You should first remove duplicates in the Query Editor and then create your new column.

cham's avatar
cham
Post Patron
6 years ago

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?