Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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_Interact...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Try:

    MaxInteractionStart = maxx(
    FILTER(
    Fact_Interaction,
    Fact_Interaction[InteractionID] =earlier(Fact_Interaction[InteractionID]) &&
    Fact_Interaction[InteractionRank] = <something goes here>
    ),
    Fact_Interaction[InteractionStartDate])
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous Try:

MaxInteractionStart = maxx(
FILTER(
Fact_Interaction,
Fact_Interaction[InteractionID] =earlier(Fact_Interaction[InteractionID]) &&
Fact_Interaction[InteractionRank] = <something goes here>
),
Fact_Interaction[InteractionStartDate])
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!