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
Solved! Go to Solution.
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)?
Proud to be a Datanaut!