Fuction Placeholder error when trying to create a month onlly calculated table

[LynnM]

Hello,

I have a YTD data souce so each month is ytd data and I need only the month data .I have created three  calculated columns to achieve this:

1. YTD FT3 = Calculate(Sum('2022 FT3'[Consolidated])): This gives me the Cumulative Consolidated

2. Previous mnth FT3 = CALCULATE([YTD FT3],PREVIOUSMONTH('Calendar'[Date])): this gives me the previous Cumulative Consolidated

3. Month FT3 =  [YTD FT3]-[Previous mnth FT3]: This gives me only the month and works perfectly.

My issue is that I need to create a calculated table that will only show me month data . My table calculation is as follows:

Month FT3 Table = CALCULATETABLE('2022 FT3',[Month FT3])

I am getting this error that I have no idea how to fix: "a Fuction Placeholder has been used in a True/False espression that is useded as a filter expression. This is not allowed"

How can I fix this? I have seen a couple of these questions but am not able to use. Thank you in advance.

[amitchandak]

@LynnM , You should try measures like examples

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

[LynnM]

Thank you for the swift response.

I used your recommended calcs as follows:

1.MTD FT3 = CALCULATE(SUM('2022 FT3'[Consolidated]),DATESMTD('Calendar'[Date]))

2. last MNTH FT3 =CALCULATE(SUM('2022FT3'[Consolidated]),DATESMTD(dateadd('Calendar'[Date],-1,MONTH)))

3. Current Mnth ft3 = [MTD FT3]-[last MNTH FT3]

When I try to create the calculated table : Month FT3 = CALCULATETABLE('2022 FT3','2022 FT3'[Current Mnth ft3]) I am still getting the error. I am not sure what I am doing.  I really appreciate your help.

[Anonymous · Accepted solution]

Hi @LynnM ,

The logic of CALCULATETABLE() function is as below. 

CALCULATETABLE(<expression>[, <filter1> [, <filter2> [, …]]])

I think [Current Mnth ft3] is a measure and you add a measure in filter field of CALCULATETABLE() function. So you will get this error. 

Here I suggest you to try SELECTCOLUMNS() function to achieve your goal.

Month FT3 =
SELECTCOLUMNS('2022 FT3',[Current Mnth ft3])

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.