Power Query : Min of group of values

[Anonymous]

Hello everyone,

I have this kind of table :

Code - Value

N1 - 1

N1 - 4
N1 - 7

N2 - 3

N2 - 5

N2 - 5

N3 - 7

N3 - 9

I want to filter data to have the minimum VALUE for each CODE like this :

N1 - 1

N2 - 3

N3 - 7

How to do it in a query in Power Query ?

Thank you.

[Mariusz · Accepted solution]

Hi @Anonymous 

You can use Group By as per below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[MFelix · Accepted solution]

Hi @Anonymous ,

You need to go to the Transform  part then Group by, select the Code as the Group by column and in the operation select Minimum of the column value:

[Anonymous]

Thank you for your answers @Mariusz and @MFelix 

The problem is that when I do this "Group by", my others columns disappears.

BEFORE

AFTER

[MFelix]

Hi @Anonymous ,

Do you want to keep all the other column and on the Value repeat the minimum value?

[dorukturkoglu]

Hi @MFelix, yes, how can this be done? I want to keep same number of records and repeat the minimum value for each group 

[MFelix]

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[dorukturkoglu]

Yes absolutely. In the sample example given above, i would like to see the following output.

Input:

N1 - 1

N1 - 4
N1 - 7

N2 - 3

N2 - 5

N2 - 5

N3 - 7

N3 - 9

Output:

N1 - 1 - 1

N1 - 4 - 1
N1 - 7 - 1

N2 - 3 - 3

N2 - 5 - 3

N2 - 5 - 3

N3 - 7 - 7

N3 - 9 - 7

[Mariusz]

Hi @Anonymous 

Please see the attached file with a solution.

This will involve some M scripting, so let me know if you need help.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Mariusz · Accepted solution]

Hi @Anonymous 

You can use Group By as per below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn