Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    some_bih
    Icon for Community Champion rankCommunity 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!