Forum Discussion
Calculating Mode
Hi, I am trying to calculate Mode from existing queries
Example:
| product | price |
| a123 | 1.2 |
| a235 | 1.5 |
| a123 | 1.2 |
| a123 | 1.2 |
| a123 | 1.3 |
| a126 | 0.3 |
i am trying to calculate the mode price for produce a123 - in this case it would be 1.2
This table is in another query, and I was thinking to create a separate query which would have my mode calculation result below:
| product | price (mode) |
| a123 | 1.2 |
| a126 | 0.3 |
| a235 | 1.5 |
Any suggestions would be incredibly helpful! Thanks!
jaclynt8
Note >> here is Two Solutions but useful First soutions bcoz second Solution in use duplicates table and it is Load our dataset .>> Right Click on Product Column >> Remove Duplicates >> Get Your Out-Put.
***************************************** Second Solutions ***********************************
>>Create Product Dulicates table >> Go to Dulicates table Home tab ribbon Advance Editor >> clear all M code and>>Add Below M Code.
let
Source = Product,
#"Grouped Rows" = Table.Group(Source,"Product",{"Price", each List.Mode([Price])})in
#"Grouped Rows"
here you get your expected result.If this post helps, please consider accept as solution to help other members find it more quickly.
3 Replies
jaclynt8
Note >> here is Two Solutions but useful First soutions bcoz second Solution in use duplicates table and it is Load our dataset .>> Right Click on Product Column >> Remove Duplicates >> Get Your Out-Put.
***************************************** Second Solutions ***********************************
>>Create Product Dulicates table >> Go to Dulicates table Home tab ribbon Advance Editor >> clear all M code and>>Add Below M Code.
let
Source = Product,
#"Grouped Rows" = Table.Group(Source,"Product",{"Price", each List.Mode([Price])})in
#"Grouped Rows"
here you get your expected result.If this post helps, please consider accept as solution to help other members find it more quickly.
Thank you! I used the second solution and it worked! I was wondering what I could do if I had two values I needed to create mode out of.
