Forum Discussion
JustinDoh1
Post Prodigy
Post ProdigyMultiple IF statements under Return
I am sharing my Pbix file here. I am trying to have multiple IF statements under Retrurn statement. I was able to possibly have up to 2 options, when I got to 3 options, I am not sure I am doing...
Tanushree_Kapse
Impactful Individual
Impactful IndividualHi JustinDoh1 ,
Try this measure for return statement:
Return
IF(OR(OR(AND(AND (min(Table1[step])= 1,NOT (min(Table1[Consent])= "Refused"), min(Table1[Consentdate])<> blank()), IFAND(AND (max(Table1[step])= 2 ,NOT (max(Table1[Consent])= "Refused"), max(Table1[Consentdate])<> blank()), AND(AND (min(Table1[step])= 1,NOT (min(Table1[Consent])= "Refused"), min(Table1[Consentdate])<> blank())), IF(AND(AND (min(Table1[step])= 1,NOT (min(Table1[Consent])= "Refused")), vimmunization < vconsent)), 0, vrefused)
I hope this helps!
Mark this as a solution if I answered your question. Kudos are always appreciated.
Thanks!