Forum Discussion
Dublicates
Hello guys, I have been faced with the following problem today. The problem seems to me to be quite trivial, but I was quite upset today. I have a bigger table with e.g. different names like "A,B,C,D,E,....". Each of these names has different monthly events. I just want to transform this data set within Power BI, in form of a table, so that I can show the duplicates (e.g. only one A,B,C,...) that had the last event. Everything else should be hidden. These data must not be deleted, because I use them for another visual. If someone has tips I would be very happy! Greetings ABBA!
Hi
on page 3 you will find both solution proposed on this post.
First visual based on Table3 that contains all your data with the solution by @mahoneypat
Last visual on page 3 based on Table by
Table = SUMMARIZE(Table3; Table3[Notification.Code];" a"; MAX(Table3[Date]))from Table3.If both could satisfy your requirement please mark as solution.Regards
13 Replies
Anonymous
Hi,
could you share some rows of data just as a sample?
Regards
Hi gpiero and other friends,
just for example:
Date Notification.Code 01.10.20 A 05.01.20 B 04.07.20 A 15.09.20 C 02.05.20 D 06.06.20 A 21.09.20 B 19.02.20 B 03.03.20 D 01.09.20 C And i want this table for example in a table visual in Power BI, but just want to see the Notification.Codes with the latest date, without deleting the others.
Thank you!
gpiero ,
this should be the solution in the visual:
Date Notification.Code 01.10.20 A 21.09.20 B 15.09.20 C 02.05.20 D Just make a table visual with the Code and Date columns, and for the Date column choose "Latest" as the aggregation (see pic).
Regards,
Pat
