cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Vvelarde Super Contributor
Super Contributor

Re: Findin MAX from multiple columns in query editor

@Anonymous

 

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


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Anonymous
Not applicable

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

Vvelarde Super Contributor
Super Contributor

Re: Findin MAX from multiple columns in query editor

@Anonymous

 

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!!


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Anonymous
Not applicable

Re: Findin MAX from multiple columns in query editor

Thanks @Vvelarde & @Greg_Deckler,

 

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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 302 members 3,022 guests
Please welcome our newest community members: