Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Custom list sorting for duplicate values

Hi all,    For example, I have this data from a review process:  ID Rating 57795 A 57795 Pass 57795 Pass 57795 A   What I want to do is have a single result returned for I...
Need Help
SamInogic's avatar
SamInogic
Super User
3 years ago

Hi,

 

Im a bit unclear about Your requirement but It seems you are Looking For a single row for Id and all the ratings of the Id in the same row,

If this is your Requirement then try this out ,

This is my Sample Table,

 

Use group by as in below Screenshot,

 


There will be a error,


To solve this us below Expression

= Table.Group(#"Changed Type", {"ID"}, {{"Result", each Text.Combine([Rating],","), type nullable

 

 

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks - very useful, to confirm I would just want the highest rating returned, but this is a useful start!

  • SamInogic's avatar
    SamInogic
    Super User
    3 years ago

    Hi Anonymous , 

     

    If you want the highest Ratings so instead of Combining, you need to Use Max of ratings in Group by as in Screenshot,

     

     


    Note that we are considering that your Ratings is Numerical column.

    Thanks!

    Inogic Professional Service Division

    An expert technical extension for your techno-functional business needs

    Power Platform/Dynamics 365 CRM

    Drop an email at [email protected]

    Service:  http://www.inogic.com/services/ 

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/