Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Anonymous
You can use Group By as per below.
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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Do you want to keep all the other column and on the Value repeat the minimum value?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix, yes, how can this be done? I want to keep same number of records and repeat the minimum value for each group
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYes 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
Hi @Anonymous
Please see the attached file with a solution.
This will involve some M scripting, so let me know if you need help.
Hi @Anonymous
You can use Group By as per below.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
105 | |
104 | |
89 | |
65 |