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,

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

Thank you so much I found it.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    You are welcome.

    • cham's avatar
      cham
      Post Patron
      6 years ago

      Hi,

       

      Is there any way that I can get the average of sales according to that state and postcode column. 

       

      I want to get the average if because there are duplicate values in state and postcode column. So I want to get the average of all the NSW2019 COLUMN. 

       

      How can I do that.

       

      I used below in Data tab and it worked. How can I do it in transform tab?

      Average Sales = CALCULATE(
      AVERAGE('Sales'[Sales]), FILTER('Sales','Sales'[PostCode and State] = EARLIER('Sales'[PostCode and State])))
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        Hi,

        It is best to write a measure (DAX formula) to solve this question rather than write a M language code.