cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Abhijitmishra Regular Visitor
Regular Visitor

Findin MAX from multiple columns in query editor

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:Example.PNG

 

Example.PNG

Thanks for the support

Abhijit

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Findin MAX from multiple columns in query editor

@Abhijitmishra

 

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

 

FILTERMAX.gif

 

Regards

 

Victor

Lima -Peru




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




5 REPLIES 5
Super User
Super User

Re: Findin MAX from multiple columns in query editor

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
Abhijitmishra Regular Visitor
Regular Visitor

Re: Findin MAX from multiple columns in query editor

Hi @Greg_Deckler,

 

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

 

 

Regards

Abhijit

Super User
Super User

Re: Findin MAX from multiple columns in query editor

@Abhijitmishra

 

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

 

FILTERMAX.gif

 

Regards

 

Victor

Lima -Peru




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Super User
Super User

Re: Findin MAX from multiple columns in query editor

Nice video!!


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Abhijitmishra Regular Visitor
Regular Visitor

Re: Findin MAX from multiple columns in query editor

Thanks @Vvelarde & @Greg_Deckler,

 

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