Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I need help extracting only max values corresponding to OriginalICERecordID(ReadyPublish) in ICERecordID(ReadyPublish) keeping all the other columns and delete the rows which do not contains max value. Length of these field is 15 char.
Here is an example:
Thanks for the support
Abhijit
Solved! Go to Solution.
@Anonymous
Hi, I have the long Version solution (I hope)
Regards
Victor
Lima -Peru
@Anonymous
Hi, I have the long Version solution (I hope)
Regards
Victor
Lima -Peru
Nice video!!
Hmm, you should be able to do this in DAX with a SUMMARIZE coupled with a MAX expression I believe but I take it that you want to do this in M (Power Query)?
Hi @Greg_Deckler,
Yes, I am able to do it via DAX, however need the same outout using M.
Regards
Abhijit
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |