Forum Discussion
Nested If Statements
Hi guys, I have 4 measures each recieving a final alpha grade (A,B,C,D). I want to use an IF statement to essentially select specific outcomes for these measures that would match or equal a select o...
cdawidow
Try this measure and replace the column names with your measure names:
Measure =
IF(
(
MAX(DATA1[Customer Sales Rank]) IN {"A","B"} &&
MAX(DATA1[Loyalty Measure]) IN {"A","B"} &&
MAX(DATA1[Margin Final]) IN {"A","B"}
) &&
(
MAX(DATA1[cts]) IN {"A","B","C","D"}
),
"GOOD",
IF(
(
MAX(DATA1[Customer Sales Rank]) IN {"A","B"} &&
MAX(DATA1[Loyalty Measure]) IN {"A","B"}
) &&
(
MAX(DATA1[Margin Final]) IN {"A","B","C","D"} &&
MAX(DATA1[cts]) IN {"A","B","C","D"}
),
"POTENTIAL"
)
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂