Forum Discussion

adoalan's avatar
adoalan
Icon for Helper III rankHelper III
3 years ago

Help with DAX formula

Hi    I need help with formula   I m getting this error:   A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

adoalan , can you share error in text format to check

  • adoalan's avatar
    adoalan
    Icon for Helper III rankHelper III
    3 years ago

    amitchandak  see below

    No Previous GAD =
    VAR StartDate = CALCULATE(MIN('Gift Aid Declarations'[Created On]), ALLSELECTED('Gift Aid Declarations'))

    VAR CurrGAD =
    FILTER (
        DISTINCT  (
            SELECTCOLUMNS (
            'Gift Aid Declarations', "Supporter ID", 'Gift Aid Declarations'[Supporter ID])
            ),
        NOT (ISBLANK([Supporter ID]))
    )  
    VAR PrevGAD = CALCULATETABLE(
        VALUES('Gift Aid Declarations'[Supporter ID]),
        'Gift Aid Declarations'[First GAD Created On] < StartDate &&
        'Gift Aid Declarations'[Supporter ID]<> BLANK()
    )

    RETURN

    IF(
        COUNTROWS(EXCEPT(CurrGAD, PrevGAD)) = BLANK(),
        0,
        COUNTROWS(EXCEPT(CurrGAD, PrevGAD))
    )