Forum Discussion
Solved
Required to keep Min and Max values - Power Query
Dear All,
I would keep only the rank column as min and max value of details from the below table using power query
EXample
Name RANK
| ARP | 1 |
| ARP | 2 |
| ARP | 3 |
| ARP | 4 |
| ARP | 5 |
| DAS | 1 |
| DAS | 2 |
| DAS | 3 |
| SAD | 1 |
Looking for
| Name | RANK |
| ARP | 1 |
| ARP | 5 |
| DAS | 1 |
| DAS | 3 |
| SAD | 1 |
2 Replies
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText( "i45WcgwKUNJRMlSK1YGxjZDYxkhsEyS2KZjt4hgM1wthGyGxIXqDHV0gamIB", BinaryEncoding.Base64), Compression.Deflate)), type table [Name = (type nullable text), Rank = (type number)]), tbl = Table.Group(Source, {"Name"}, {{"Rank", each List.Distinct({List.Min([Rank]),List.Max([Rank])})}}), tbl1 =Table.ExpandListColumn(tbl, "Rank"), Result = Table.TransformColumnTypes(tbl1,{{"Rank", Int64.Type}}) in Result
