Error With Calculated Dimension

[cgT]

=date(if(PerformanceWeekCommencing = {'>=$(=WeekStart(Today()-7))'}, PerformanceWeekCommencing), 'DD/MM/YY')

Hi,

I am trying to using the above set analysis in a calculated dimension. However, the expression editor is returning "Error in expression: ')' expected".

I can't see why, though. From what I can see the syntax is correct.

Thank you 

[Or · Accepted solution]

That syntax is not correct. You're trying to use set analysis in a context that does not accept set analysis (and your set analysis would be incorrect in any case, I think).

if(PerformanceWeekCommencing >= WeekStart(Today()-7),PerformanceWeekCommencing)

[Lakshmanan]

If you want apply Set analysis on Dimension : aggr(ONLY({<YEAR={'2023'}>}Id),ID)

Please mark as resolved if it solved the issue.