placeholder error in measure

[StefanH74]

Hi,

I have 2 measures: 

- one to determine the last output-date of a product, this one works just fine, and does indeed return the correct date

last outputdate = CALCULATE(MAX(fctArtikelposten[Posting_Date]),FILTER(fctArtikelposten,fctArtikelposten[Entry_Type]="Output"))

then I have a second measure to determine the first sales-date after the last outputdate (from measure 1)

1e salesdate after last outputdate = CALCULATE(CALCULATE(MIN(fctArtikelposten[Posting_Date]),fctArtikelposten[Entry_Type]="Sales"),fctArtikelposten[Posting_Date]>=[last outputdate])

on this last measure I get an error: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

anyone know how to fix this??

Thanx, Stefan

[StefanH74 · Accepted solution]

Thanx to everyone for trying to help.

unfortunately your solutions did not work for me.

But I managed to get the desired result, not by making a measure, but rather 2 calculated columns in my Item table

[tamerj1]

@StefanH74 

Good job 👏 

[Anonymous]

Hi @StefanH74 ,

Please check the formulas. ALLEXCEPT() is to do the calculation based on [product].

last outputdate =
CALCULATE (
    MAX ( fctArtikelposten[Posting_Date] ),
    FILTER (
        ALLEXCEPT ( fctArtikelposten, [product] ),
        fctArtikelposten[Entry_Type] = "Output"
    )
)

1e salesdate after last outputdate =
CALCULATE (
    MIN ( fctArtikelposten[Posting_Date] ),
    FILTER (
        ALLEXCEPT ( fctArtikelposten, [product] ),
        fctArtikelposten[Entry_Type] = "Sales"
            && fctArtikelposten[Posting_Date] >= [last outputdate]
    )
)

Best Regards,

Jay

[StefanH74]

problem seems to be in this date-filter. this measure also ignores the filter

test = CALCULATE(MIN(fctArtikelposten[Posting_Date]),FILTER(fctArtikelposten,fctArtikelposten[Posting_Date]>=[last outputdate]))

 or

test2 = MINX(CALCULATETABLE(fctArtikelposten,FILTER(fctArtikelposten,fctArtikelposten[Posting_Date]>=[last outputdate])),fctArtikelposten[Posting_Date])

I'd love to hear it if somebody has an idea what I'm doing wrong.

[StefanH74]

ok, I found that the problem lies somewhere in the "last outputdate" - measure

because if I put in a hard value in measure 2, then it works correctly

test = CALCULATE(MIN(fctArtikelposten[Posting_Date]),FILTER(fctArtikelposten,fctArtikelposten[Posting_Date]>=43830))

This will give me the first date there was activity on an article after 31-12-2019 (=43830)

still no idea on how to fix it though, or why it wont accept the "last outputdate" instead

[tamerj1]

@StefanH74 
Perfect. Good job!

[tamerj1]

Hi @StefanH74 

please try

2ndMeasure =
CALCULATE (
    CALCULATE (
        MIN ( fctArtikelposten[Posting_Date] ),
        fctArtikelposten[Entry_Type] = "Sales"
    ),
    FILTER ( fctArtikelposten, fctArtikelposten[Posting_Date] >= [last outputdate] )
)

[StefanH74]

This does indeed remove the PLACEHOLDER error, only the measure is wrong, it returns the very first sales date, not the first after the last output-date. I looks like it doesnt apply the last filter:

FILTER ( fctArtikelposten, fctArtikelposten[Posting_Date] >= [last outputdate]