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...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, watje255_ju 

 

Month =

 

CALCULATE(

 

    [Stock On Hand],

 

  Filter (table name,  [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)

 

)

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

And the same logic for 7-12 months returns the above values when I am after 309 

Thanks again 🙂