topic A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp in DAX Commands and Tips

A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp

Anonymous — Fri, 06 Oct 2023 09:05:47 GMT

closed_sku_count_lastmonth =
VAR eolm = ENDOFMONTH(DATEADD('Date'[Date], -1, MONTH))
RETURN
CALCULATE(
COUNT(dc_fact_table[item_code]),
[status] = "closed",
'Date'[Date] = eolm
)
This error appear when I wrote this

Re: A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp

some_bih — Fri, 06 Oct 2023 10:02:07 GMT

Hi Anonymous try below

closed_sku_count_lastmonth_test =
VAR eolm = ENDOFMONTH(DATEADD('Date'[Date], -1, MONTH))
RETURN
CALCULATE(
COUNT(dc_fact_table[item_code]),
[status] = "closed",
FILTER('Date','Date'[Date] = eolm
)
)

Did I answer your question? Kudos appreciated / accept solution!