Operator or expression () is not supported in this context

[SalCambs]

Hello

I am struggling with this dax and getting the above error.  I cannot work out what is wrong with my syntax.  Any help would be gratefully received:

[bhanu_gautam · Accepted solution]

@SalCambs , Try using 

CIC at End of Month =
CALCULATE(
COUNTROWS('Annex A List 8 v2'),
'Annex A List 8 v2'[Date started to be Looked After] <= EOMONTH(MAX(DateTable[Date]), 0),
OR(
'Annex A List 8 v2'[Date Ceased to be Looked After] >= EOMONTH(MAX(DateTable[Date]), 0),
ISBLANK('Annex A List 8 v2'[Date Ceased to be Looked After])
)
)

[Kedar_Pande · Accepted solution]

Try:

CIC at End of Month = 
CALCULATE (
COUNTROWS ( 'Annex A List 8 V2' ),
'Annex A List 8 V2'[Date Started to be Looked After] <= EOMONTH ( MAX ( DateTable[Date] ), 0 )
&& (
'Annex A List 8 V2'[Date Ceased to be Looked After] > EOMONTH ( MAX ( DateTable[Date] ), 0 )
|| ISBLANK ( 'Annex A List 8 V2'[Date Ceased to be Looked After] )
)
)

If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[bhanu_gautam · Accepted solution]

@SalCambs , Try using 

CIC at End of Month =
CALCULATE(
COUNTROWS('Annex A List 8 v2'),
'Annex A List 8 v2'[Date started to be Looked After] <= EOMONTH(MAX(DateTable[Date]), 0),
OR(
'Annex A List 8 v2'[Date Ceased to be Looked After] >= EOMONTH(MAX(DateTable[Date]), 0),
ISBLANK('Annex A List 8 v2'[Date Ceased to be Looked After])
)
)