Help with DAX formula

[adoalan]

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.

[v-henryk-mstf]

Hi @adoalan ,

I am unable to reproduce this question for the time being. Can you provide the relevant test data and describe it so that I can answer it for you as soon as possible?

(1) How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry

[adoalan]

And the error is this

A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

[amitchandak]

@adoalan , can you share error in text format to check

[adoalan]

@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))

)