topic Re: Power BI Dublicates in DAX Commands and Tips

Power BI Dublicates

Anonymous — Mon, 19 Oct 2020 10:32:57 GMT

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! !

An example table:

Date	Notification.Code	ed	erg	grewg	qreg	qerg	qerge	qrge	qg	qrg	qrg	resume date
01.10.20	A	A567	248	248	248	248	248	248	248	248	248	04.02.20
05.01.20	B	D3456	248	248	248	248	248	248	248	248	248	05.02.20
04.07.20	A	F247	248	248	248	248	248	248	248	248	248	06.02.20
15.09.20	C	G248	249	250	251	252	253	254	255	256	257	07.02.20
02.05.20	D	J249	250	251	252	253	254	255	256	257	258	08.02.20
06.06.20	A	S250	251	252	253	254	255	256	257	258	259	09.02.20
21.09.20	B	X251	252	253	254	255	256	257	258	259	260	10.02.20
19.02.20	B	X252	253	254	255	256	257	258	259	260	261	11.02.20
03.03.20	D	C253	254	255	256	257	258	259	260	261	262	12.02.20
01.09.20	C	U254	255	256	257	258	259	260	261	262	263	13.02.20

Regards!

ABBA

Re: Power BI Dublicates

rks — Mon, 19 Oct 2020 10:53:45 GMT

Hi Abba, have you already tried some solutions?

What is the desired output? A measure or a table?

Re: Power BI Dublicates

Anonymous — Mon, 19 Oct 2020 10:57:33 GMT

Hi rks ,

yes i tried a table visual and group by latest on the dates, but it doesnt work.

Regards,

Abba

Re: Power BI Dublicates

rks — Mon, 19 Oct 2020 14:51:31 GMT

Ok, I would probably do something like this (not testet)

MINX(

SUMMARIZE('Table', 'Table'[NotificationCode], 'Table'[Date]), -- or what every granularity you need

CALCULATE(min(resumdate))

)

If necessary remove the filters from the table with ALL()

Re: Power BI Dublicates

Anonymous — Mon, 19 Oct 2020 20:59:48 GMT

Hey rks ,

thank you!! I dont get the right dates 😕

This is what I get with this measure.

Any ideas why?

Re: Power BI Dublicates

Anonymous — Tue, 20 Oct 2020 10:19:10 GMT

You can create a reference table from main table in power query and even you can delete unsue column from it .
just right click on main table and select reference and bingo .

then delete unuse column.

Thank you