cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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!

1 ACCEPTED SOLUTION
Super User

@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 3
Super User

Super User

@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.

Frequent Visitor

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.