cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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 column in data tab so that column is not appearing in transform tab.

 

Also, Can i create concatenate in transform table? I want to add text and num value. Its giving an error we cannot combine text and value in tarnsform concatenate.

 

Thnaks

C

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

17 REPLIES 17
Highlighted
Highlighted
Super User III
Super User III

Hi,

You should first remove duplicates in the Query Editor and then create your new column.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted

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.

Highlighted

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?

Highlighted

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Highlighted

can you please provide it with example.

 

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

Highlighted

Thank you so much I found it.

Highlighted

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted

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])))

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors