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

Question

Hello;&nbsp;When trying to run a calculation I am getting the error described in the title.Here is the dax expression:&nbsp;currentMonthPunchedHours = CALCULATE(sum(punches[hours]), and(True, and(YEAR(punches[punchIn]) * 12 + MONTH(punches[punchIn]) = YEAR(TODAY()) * 12 + MONTH(TODAY()), and(YEAR(punches[punchOut]) * 12 + MONTH(punches[punchOut]) = YEAR(TODAY()) * 12 + MONTH(TODAY()), day(punches[punchIn]) &lt; day('measure stuff'[breakEnd])))))&nbsp;Thanks for the help

fowmy · Answer

Anonymous&nbsp;Can you try this version:
currentMonthPunchedHours =
CALCULATE (
    SUM ( punches[hours] ),
    FILTER (
        ALL ( punches ),
        AND (
            YEAR ( punches[punchIn] ) * 12 + MONTH ( punches[punchIn] ) = YEAR ( TODAY () ) * 12 + MONTH ( TODAY () ),
            AND ( YEAR ( punches[punchOut] ) * 12 + MONTH ( punches[punchOut] ) = YEAR ( TODAY () ) * 12 + MONTH ( TODAY () ),
                DAY ( punches[punchIn] ) &lt; DAY ( 'measure stuff'[breakEnd] )
            )
        )
    )
)

fowmy · Answer

Anonymous&nbsp;I added a Dates table and calculated the four measures as requested, please check the attached PBIX file below my signature.
---------------------------------
-- Calculated Table: '__Measures'
---------------------------------
TABLE '__Measures' = {BLANK()}

-------------------------
-- Measure: [Punch Hours]
-------------------------
MEASURE '__Measures'[Punch Hours] = 
    VAR __CurrentDate = MAX('Dates'[Date])
    VAR __MonthStart = EOMONTH(MAX('Dates'[Date]),-1)+1
    RETURN
    CALCULATE(
        SUM(punches[hours]),
        punches[punchIn] &gt;= __MonthStart,
        punches[punchOut] &lt;= __CurrentDate
    )

----------------------------
-- Measure: [Punch Hours PM]
----------------------------
MEASURE '__Measures'[Punch Hours PM] = 
    VAR __CurrentDate = EDATE(MAX('Dates'[Date]),-1)
    VAR __MonthStart = EOMONTH(MAX('Dates'[Date]),-2)+1
    RETURN
    CALCULATE(
        SUM(punches[hours]),
        punches[punchIn] &gt;= __MonthStart,
        punches[punchOut] &lt;= __CurrentDate
    )

----------------------------
-- Measure: [Schedule Hours]
----------------------------
MEASURE '__Measures'[Schedule Hours] = 
    VAR __CurrentDate = MAX('Dates'[Date])
    VAR __MonthEnd = EOMONTH(MAX('Dates'[Date]),0)
    RETURN
    CALCULATE(
        SUM(scheduled[hours]),
        scheduled[begDate] &gt; __CurrentDate,
        scheduled[endDate] &lt;= __MonthEnd
    )

-------------------------------
-- Measure: [Schedule Hours PM]
-------------------------------
MEASURE '__Measures'[Schedule Hours PM] = 
    VAR __CurrentDate = EDATE(MAX('Dates'[Date]),-1)
    VAR __MonthEnd = EOMONTH(MAX('Dates'[Date]),-1)
    RETURN
    CALCULATE(
        SUM(scheduled[hours]),
        scheduled[begDate] &gt; __CurrentDate,
        scheduled[endDate] &lt;= __MonthEnd
    )

anonymous · Answer

Thank you,The query is not giving error anymore but I am not getting any data.The breakEnd is set to be the maximum value of a date column used on a slider if that might help.

fowmy · Answer

Anonymous&nbsp;In this case, you will need to share a sample or dummy file showing the scenario and the exepected results.&nbsp;Please save your file in Cloud file storage service like google drive and share the link here

anonymous · Answer

Here is a powerbi containing a sample:https://anonfiles.com/jfO1h563y3/dummyDash_pbix&nbsp;I would like to be able to use a slider selecting a day and then calculate:- the sum of the punches hours from the begining of the current month until the day in the slider- the sum of the scheduled hours from the end of the slider to the end of the month- the sum of punched hours of previous month until slider value- the sum of the scheduled hours of the previous month from slider value to end of month&nbsp;Thank you very much.

Forum Discussion

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

10 Replies

Related content

The True/False expression does not specify a column. Each True/False expressions used as a table

True/False expression does not specify a column. Each True/False expressions used as a table filter

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

The True/False expression does not specify a column. Each True/False expressions used as a table fil

True/False, if statement