Hi Team,
I'm looking for help with Power Query to achieve the following...
Here's my data:
<tbody>
</tbody>
I want to extract the records for each Product where the biggest Sales have taken place. The result should be as follows:
<tbody>
</tbody>
Can anyone help me with this? To reiterate: I would like M code for this if possible, not DAX.
Thanks,
Matty
I'm looking for help with Power Query to achieve the following...
Here's my data:
Product | Type | Sales |
---|---|---|
Apple | Bag | 11 |
Apple | Box | 4 |
Pear | Bag | 7 |
Banana | Bunch | 8 |
Orange | Bag | 12 |
Orange | Box | 4 |
<tbody>
</tbody>
I want to extract the records for each Product where the biggest Sales have taken place. The result should be as follows:
Product | Type | Sales |
---|---|---|
Apple | Bag | 11 |
Pear | Bag | 7 |
Banana | Bunch | 8 |
Orange | Bag | 12 |
<tbody>
</tbody>
Can anyone help me with this? To reiterate: I would like M code for this if possible, not DAX.
Thanks,
Matty