Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to exclude the first month data from a line chart and use the expression below:
=if(Utilization_Date > monthend(min(Utilization_Date)), [Utilization_Date.autoCalendar.YearMonth])
Could anyone tell me why it returns the 'invalid dimension' error?
Try below, since Aggregate functions are not allowed without aggregate
=if(Utilization_Date > monthend(Aggr(min(Utilization_Date), Utilization_Date)), [Utilization_Date.autoCalendar.YearMonth])