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.

  • cham's avatar
    cham
    Post Patron
    6 years ago

    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.