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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Maxx Function Filtering on two columns?

EDIT: For anyone that finds this on Google, the solution is, as the guy below said:

 

MaxInteractionStart = maxx(
FILTER(
Fact_Interaction,
Fact_Interaction[InteractionID] =earlier(Fact_Interaction[InteractionID]) &&
Fact_Interaction[InteractionRank] = <something goes here>
),
Fact_Interaction[InteractionStartDate])

thanks a bunch @Greg_Deckler 

 

Original Q below:

 

So I know how to get the max of something based on colummn but I would like to filter by two columns.

See the function below, this gives me the max date for every InteractionID, but I also have an Interaction Rank so I would like the max InteractionStartDate based on both InteractionID and InteractionRank, where would I add this in?

MaxInteractionStart = maxx(
FILTER(
Fact_Interaction,
Fact_Interaction[InteractionID] =earlier(Fact_Interaction[InteractionID])
),
Fact_Interaction[InteractionStartDate])

 

 

how would I add a second filter for InteractionRank?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Anonymous Try:

MaxInteractionStart = maxx(
FILTER(
Fact_Interaction,
Fact_Interaction[InteractionID] =earlier(Fact_Interaction[InteractionID]) &&
Fact_Interaction[InteractionRank] = <something goes here>
),
Fact_Interaction[InteractionStartDate])


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@Anonymous Try:

MaxInteractionStart = maxx(
FILTER(
Fact_Interaction,
Fact_Interaction[InteractionID] =earlier(Fact_Interaction[InteractionID]) &&
Fact_Interaction[InteractionRank] = <something goes here>
),
Fact_Interaction[InteractionStartDate])


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hey, This actually worked! I actually had this code before and was getting a syntax error because I had put my contact rank in quotations (thus having the function look for text instead of the number.) It worked, but just one request, the earlier() bit of the function does not seem to be doing what I want it to do, is there are better function that will get the filter to look through all instances of the InteractionIDs in my table?

 

Thanks bro!

Helpful resources

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