Poor performance IF measure
Hello, I have created a measure that has horrible performance: _Active License = VAR ExpiresInFuture = LASTDATE ( LineItem[Opportunity Line End Date] ) >= LASTDATE ( ReferenceDate[Reference Date] ) VAR ExpiresInPast = LASTDATE ( LineItem[Opportunity Line End Date] ) <= LASTDATE ( ReferenceDate[Reference Date] ) VAR StartsInFuture = FIRSTDATE ( LineItem[Opportunity Line Start Date] ) >= LASTDATE ( ReferenceDate[Reference Date] ) VAR StartsInPast = FIRSTDATE ( LineItem[Opportunity Line Start Date] ) <= LASTDATE ( ReferenceDate[Reference Date] ) RETURN IF ( ExpiresInPast, "Expired", IF ( StartsInPast && ExpiresInFuture, "Active", IF ( StartsInFuture && ExpiresInFuture, "Future", "Error" ) ) ) This is not even running for low granularity.. not sure how I can optimize it to run under 3ms. The output should tell me if a license if expired, active or future based on the row level start and end date. Thank you
