monthStart lesser than dimension date in set analysis

Morgoz — Thu, 03 Jun 2021 16:06:17 GMT

Hello,

I want to show a count of number of errors detected before the start date of the current month in dimension.

This test works fine:

Count({<ERROR_DETECTION_DATE_QVD = {"$(='<='&'2021-05-01')"}>}ID_DQ_FACTS_QVD)

But this other code is not taking into account the condition of the monthStart, and it is returning all errors, not only the ones before monthStart:

Count({<ERROR_DETECTION_DATE_QVD = {"$(='<='&monthStart(EXEC_DATE_SQL_QVD))"}>}ID_DQ_FACTS_QVD)

EXEC_DATE_SQL_QVD is the current dimension date.

What am I doing wrong?

Thank you.

topic monthStart lesser than dimension date in set analysis in App Development