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 again still not working properly, can you access the PBIX File? 

 

For the first example i get the same error as noted in the original post, and the second formula doesn't return the expect values for the buckets when altering the formula for 13+ months for example, thanks again for your help

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

    Hi, thanks for your reply, the formula isn't working as expected, I should only be getting 39,198 , not 39,809, do you know why? Thanks!!

  • 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 🙂