Findin MAX from multiple columns in query editor

[Anonymous]

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

[Vvelarde · Accepted solution]

@Anonymous

Hi, I have the long Version solution (I hope)

Regards

Victor

Lima -Peru

[Anonymous]

Thanks @Vvelarde & @Greg_Deckler,

It solved my issue, however still looking for a shorter solution.

[Greg_Deckler]

Nice video!!

[Greg_Deckler]

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)?

[Anonymous]

Hi @Greg_Deckler,

Yes, I am able to do it via DAX, however need the same outout using M.

Regards

Abhijit