Forum Discussion
Anonymous
2 years agoNot applicable
A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp
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 a...
some_bih
Community Champion
2 years agoHi 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!