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 will need to share that other table as well.  Show the exact result that you are expecting to see in the other table.

cham's avatar
cham
Post Patron
6 years ago

Thanks. I found a way.