Forum Discussion

bonjourposte's avatar
bonjourposte
Helper V
1 year ago
Solved

A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp

Hi all, I'm getting this error message with my measure, trying to figure out the number of Renewals and Extensions we've done in the past year.  What does it want me to change?         ...
  • PijushRoy's avatar
    1 year ago

    Hi bonjourposte 
    Can you please check the below DAX, please let me know if not works

    NumRenewals2 = 
    VAR MatDate = MAX(LOANHISTSorted[MAT_DATE])
    VAR CurrentLoanStatus = MAX(LOANHISTSorted[LOAN_STATUS])
    VAR CurrentLoanTerm = MAX(LOANHISTSorted[CURR_LOAN_TERM])
    VAR CurrentAmzMos = MAX(LOANHISTSorted[CURR_AMZ_MONTHS])
    
    VAR PREV_MAT_DATE = MAX(LOANHISTSorted[PREV_MAT_DATE])
    VAR PREV_LOAN_STATUS = MAX(LOANHISTSorted[PREV_LOAN_STATUS])
    VAR PREV_LOAN_TERM = MAX(LOANHISTSorted[PREV_LOAN_TERM])
    VAR PREV_AMZ_MOS = MAX(LOANHISTSorted[PREV_AMZ_MONTHS])
    VAR PREV_START_DATE = MAX(LOANHISTSorted[PREV_START_DATE])
    
    RETURN
        CALCULATE(
            COUNTROWS(LOANHISTSorted),
            FILTER(
                LOANHISTSorted,
                MatDate <> PREV_MAT_DATE &&
                CurrentLoanStatus <> "Commitment" &&
                PREV_LOAN_STATUS <> "Cancelled" &&
                PREV_LOAN_STATUS <> "PAIDINFULL" &&
                (
                    (PREV_START_DATE > MatDate) || 
                    (PREV_LOAN_TERM <> CurrentLoanTerm && PREV_AMZ_MOS = CurrentAmzMos)
                )
            )
        )