I am trying to use the filter function in my Report Filters.
Below is my SQL statement in the report filter but it throws an error that Filter needs an aggregate measure in the first expression.
Finance.Date = FILTER(Max(Finance.date) USING ABC."Report Period" = 'Daily" AND DEF."Region"="NA")
Is there something that I am missing here.
The requirement is to match the date with the max date using the conditions mentioned above in the filter function.
Any help will be greatly appreciated.
Exact Error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 22038] Function FILTER requires at least one measure attribute in its first argument. (HY000)