Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@spitfyah Try:
MaxInteractionStart = maxx(
FILTER(
Fact_Interaction,
Fact_Interaction[InteractionID] =earlier(Fact_Interaction[InteractionID]) &&
Fact_Interaction[InteractionRank] = <something goes here>
),
Fact_Interaction[InteractionStartDate])
@spitfyah Try:
MaxInteractionStart = maxx(
FILTER(
Fact_Interaction,
Fact_Interaction[InteractionID] =earlier(Fact_Interaction[InteractionID]) &&
Fact_Interaction[InteractionRank] = <something goes here>
),
Fact_Interaction[InteractionStartDate])
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |