Forum Discussion
watje255_ju
Helper III
Helper IIIA 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
Resident Rockstar
Resident RockstarHi, 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_juHelper III
Helper IIIHi, 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!!