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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
HIGGS1989
Frequent Visitor

Get the Min number of a dataset based on multiple columns?

So I have the following data set: 

 

grouprnkbuckets# loans
bucket1-0345
bucket1-05467
bucket112453
bucket11222
bucket112125
bucket2142565
bucket2144232
bucket214213
bucket217123
bucket21712
bucket21745
bucket217567

 

I need to create a new column that looks for the Minimun value of those groups taking into consideration that there are multiple type of groups instead of buckets and the rankc column alongside with the buckets will change. So for example:

 

grouprnkbuckets# loansMin value
bucket1-0345345
bucket1-05467345
bucket11245322
bucket1122222
bucket11212522
bucket2142565213
bucket2144232213
bucket214213213
bucket21712312
bucket2171212
bucket2174512
bucket21756712

 

As you can see a new column is added with the MIN value of the data as mentioned above. How can I do this using DAX?

1 REPLY 1
FreemanZ
Super User
Super User

hi @HIGGS1989 

try like:

MinValue =
MINX(
    FILTER(
        TableName,
        TableName[group]=EARLIER(TableName[group])
&&TableName[rnk]=EARLIER(TableName[rnk])
&&TableName[buckets#]=EARLIER(TableName[buckets#])
    ),
    TableName[loans]
)

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.