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.
Go to Solution.
It is best to write a measure (DAX formula) to solve this question rather than write a M language code.
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?
I cnanot understand your question. Share your data, explain the business context and show the expected result.
This is the table,
I want to get the average of lat for 7000 TAS. There are 6 lat records for 7000 TAS. So I want to get the average for that. Likewise I want to get the averageif for all the data.
Click on the Table visual and drag the 2 fields Suburb and Post code to the visual. Write this measure
Hope this helps.
I want to get the avarage of lat and vlookup it to ther other sheet. Its not about showing the avaerage in a table.
So without doing thses in Power BI its better to do ot in Excel right? But if there is anyway to remove duplicates in Data tab I can get the correct results.
You will need to share that other table as well. Show the exact result that you are expecting to see in the other table.
Thanks. I found a way.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021