How to get rid of duplicates after summarizecolumns()

[leisay]

Dear all, 

I am quite new to PowerBI. I created a new table using the summerizecolumns() function. But I found out there are still duplicates in the column vehicle. I assume that that there are 4 vehicles, which have two dates. 

How can I get rid of the duplicates in the vehicle column? Maybe taking only one of the dates, which belongs to this vehicle? 

Thanks a lot in advance!

[az38]

@leisay 

so, what do you expect?

it seems like you have more than one Date on a few vehicles. you need to define aggregation rules for Date field if you want to have only unique vehicles

[leisay]

@az38 Thank you for the quick reply. 

I looked into the data and I found out some vehicles have 2 dates as shown in the screenshot. 

My plan is to take the first date and eliminate the 2nd record from this vehicle. But I have no idea how. 

[v-deddai1-msft · Accepted solution]

Hi @leisay

 

Would you please try the following calculated table:

Table 2 = SUMMARIZECOLUMNS('loading'[Vehicle],"Date",FIRSTNONBLANKVALUE('loading'[Vehicle],MIN('loading'[GI Date])))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai