Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jaclynt8
Frequent Visitor

Calculating Mode

Hi, I am trying to calculate Mode from existing queries

Example: 

 

productprice
a1231.2
a2351.5
a1231.2
a1231.2
a1231.3
a1260.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:

productprice (mode)
a1231.2
a1260.3
a2351.5

Any suggestions would be incredibly helpful! Thanks! 

1 ACCEPTED SOLUTION
Mahesh0016
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.

Mahesh0016_1-1671770612772.png

 

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

View solution in original post

3 REPLIES 3
wdx223_Daniel
Super User
Super User

wdx223_Daniel_0-1671777103798.png

 

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

Mahesh0016_1-1671770612772.png

 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.