Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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
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)
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)
If you want apply Set analysis on Dimension : aggr(ONLY({<YEAR={'2023'}>}Id),ID)
Please mark as resolved if it solved the issue.