Forum Discussion

watje255_ju's avatar
watje255_ju
Icon for Helper III rankHelper III
2 years ago

A function 'PLACEHOLDER' has been used in a True/False expression error in aging calculation

I am wanting to create aging bands for Inventory - for example stock shelf life 0-1 months, 1-6 months, 7-12 months 13+, but when i try the dax measure  , i get the error A function 'PLACEHOLDER' has...
watje255_ju's avatar
watje255_ju
Icon for Helper III rankHelper III
2 years ago

Thanks for your reply! I am not filtering the table, but a measure, 

Stock On Hand with Shelf Life > 1 Month =
CALCULATE(
    [Stock On Hand],
    [Shelf Life Remaining] > 1
) or 
Stock On Hand with Shelf Life 1-6 Months =
CALCULATE(
    [Stock On Hand],
    [Shelf Life Remaining] >= 1 && [Shelf Life Remaining] <= 6
)
 
Would you mind showing the correct Dax formula in the PBIX (link above) Thanks again!
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, watje255_ju 

 

Try below

Month =

CALCULATE(

    [Stock On Hand],

    [Shelf Life Remaining] > 1

) or 

Stock On Hand with Shelf Life 1-6 Months =

CALCULATE(

    [Stock On Hand],

    Filter (tablename,[Shelf Life Remaining] >= 1 && [Shelf Life Remaining] <= 6)

)