Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Hi Abba, have you already tried some solutions?
What is the desired output? A measure or a table?
Hi @rks ,
yes i tried a table visual and group by latest on the dates, but it doesnt work.
Regards,
Abba
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()
Hey @rks ,
thank you!! I dont get the right dates 😕
This is what I get with this measure.
Any ideas why?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |