Forum Discussion
Operator or expression () is not supported in this context
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:
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])
)
)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
2 Replies
- bhanu_gautam
Super User
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
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