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

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.

    • cham's avatar
      cham
      Post Patron
      6 years ago

      Yea that;'s the issue. I have get the average but I cannot remove duplicates in data tab.

       

      I can remove duplicates in tranform tabl but I cannot get the average it before removing duplicates.

       

      I sthere any way that I can do this?

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        Hi,

        I cnanot understand your question.  Share your data, explain the business context and show the expected result.