Where does ELSIF come from?
Please try this,
MAX(IIF([Primary Member Type Description] = "Basic", 1,0),IIF([Line Status Code] = "C", 1,0))=1
That did not work.
I'm trying to create a calculated/dynamic set of customer ids for my basic members. This way i won't have to create one each month to see if my basic members upgraded or lapsed to a lesser category. The calculation is done my customer id dimension and my numbers are higher than what they should be per month.
The formula doesn't look right, don't think you can have the ELSEIF nested between IIF statements.
MAX(IF [Primary Member Type Description] = "Basic" THEN 1 ELSEIF [Line Status Code] = "C" THEN 1 ELSE 0 END)=1
Not sure that'll give you the results you expect but the syntax should be ok.
We cant use Else if without IF statement. But if you looking for nested IIF, then below should work. Logically, if the first IIF statement turns fall, the next IIF statement will be executed.
MAX(IIF([Primary Member Type Description] = "Basic",1,IIF([Line Status Code] = "C",1,0)))=1