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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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