should not use function as part of calculate filter boolean expression?

[Anonymous]

Hi

why line 5 works well but line 6 error cause of A function 'ENDOFMONTH' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

 1 Inflow_KPI2 =
2 VAR CurDate = ENDOFMONTH(Inflow_non5g[Date])
3 RETURN
4 CALCULATE( MAX(Inflow_non5g[O&M OSS&EMS]),
5      //Inflow_non5g[Date] = CurDate
6     Inflow_non5g[Date] = ENDOFMONTH(Inflow_non5g[Date])
7 )

Thanks a lot!

[v-yulgu-msft]

Hi @Anonymous ,

You should modify the formula as below:

Inflow_KPI2 =
VAR CurDate = ENDOFMONTH(Inflow_non5g[Date])
RETURN
CALCULATE( MAX(Inflow_non5g[O&M OSS&EMS]),
Inflow_non5g[Date] = FILTER(Inflow_non5g,Inflow_non5g[Date]=ENDOFMONTH(Inflow_non5g[Date])))

Best regards,

Yuliana Gu

[Anonymous]

@v-yulgu-msft  Thanks for help.

post from you should work, but i want to know why

 1 Inflow_KPI2 =
2 VAR CurDate = ENDOFMONTH(Inflow_non5g[Date])
3 RETURN
4 CALCULATE( MAX(Inflow_non5g[O&M OSS&EMS]),
5      Inflow_non5g[Date] = CurDate
6 )

works well. But

 1 Inflow_KPI2 =
2 VAR CurDate = ENDOFMONTH(Inflow_non5g[Date])
3 RETURN
4 CALCULATE( MAX(Inflow_non5g[O&M OSS&EMS]),
5     Inflow_non5g[Date] = ENDOFMONTH(Inflow_non5g[Date])
6 )

cannot, but error with A function 'ENDOFMONTH' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

What's the difference between these two?

Regards