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?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    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.

    • cham's avatar
      cham
      Post Patron
      6 years ago

      can you please provide it with example.

       

      using the column names. One column is "post code" other one is "state".

    • cham's avatar
      cham
      Post Patron
      6 years ago

      Thank you so much I found it.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        You are welcome.