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
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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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