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
GuillaumePower
Resolver I
Resolver I

How create class inside a column

Hello, i would like create class inside a column, to sum some product  by  this class, for example create a class all the 10 items from my column and give it a number or  letter.

 

Thanks in advance

 

class with letter for each group  of 3 numbers

 

 

1A
2A
3A
4B
5B
6B
7C
8C
9C
10D
11D
12D
13E
14E
15E
16F
17F
18F
19G
20G
21G
1 ACCEPTED SOLUTION

Interesting. That function is not listed in the official documentation

lbendlin_1-1709348526757.png

but when you spell it out it will appear

 

lbendlin_0-1709348485539.png

 

The inofficial documentation is equally vague SAMPLEAXISWITHLOCALMINMAX – DAX Guide

This article makes a reference that may help more  Chris Webb's BI Blog: DAX Machine Learning Functionality Used By The Key Influencers Visual In Power...

 

View solution in original post

3 REPLIES 3
GuillaumePower
Resolver I
Resolver I

In fact,  I  want to divide in some groups a table without using an expression like a switch (A :if >10;B if > 20 and so on).

Simply create 3 class in a table with the same number of elements in each class.

I think that the function SAMPLEAXISWITHLOCALMINMAX could help me, but I have not found the right way to use it. Is it more clear ?

Interesting. That function is not listed in the official documentation

lbendlin_1-1709348526757.png

but when you spell it out it will appear

 

lbendlin_0-1709348485539.png

 

The inofficial documentation is equally vague SAMPLEAXISWITHLOCALMINMAX – DAX Guide

This article makes a reference that may help more  Chris Webb's BI Blog: DAX Machine Learning Functionality Used By The Key Influencers Visual In Power...

 

lbendlin
Super User
Super User

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

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.