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 appear when I wrote this
1 Reply
- some_bih
Community Champion
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!