Visual has exceeded available resources. How to improve DAX query performance?

Question

Hi All,&nbsp;I have a Matrix visual that is used to calculate various measures which when published to service gives an error "Visual has exceeded available resources"I have narrowed down to 3 measures whose performance is causing the matrix to slow down.&nbsp;Last Period of Favourable Var (In 1 Year) = VAR __YearShift = 1 //max number of years to look backVAR __MaxDate = MAX('Calendar'[Date]) //latest dateVAR __MinDate = DATE(YEAR(__MaxDate) - __YearShift, MONTH(__MaxDate), 1) //the first date to appear in calendarVAR __FilteredCal = FILTER(ALL('Calendar'), 'Calendar'[Date] &gt;= __MinDate &amp;&amp; 'Calendar'[Date] &lt;= __MaxDate) //calendar filtered by min and max dates defined aboveVAR __LastPeriod = CALCULATE(LASTNONBLANK('Calendar'[Date], [Positive Var]), __FilteredCal) //Calculates last periodRETURN IF(ISBLANK(__LastPeriod), __MinDate, __LastPeriod) //returns min period if there is blank because we only look back that far&nbsp;# of Months Unfavourable Var = Var x=[Last Period of Favorable Var (In 1 year)]Var y=[MaxDate]return(DATEDIFF(x,y,MONTH))&nbsp;Sum in period = CALCULATE([Gross Margin Var],DATESBETWEEN('Calendar'[Date],[Next Month Same Day],MAX('Calendar'[Date])))&nbsp;/*Next Month Same Day = VAR CurrentDate = [Last Period of Favorable Var (In 1 year)]VAR FirstDayOfNextMonth = EOMONTH(CurrentDate,0) + 1VAR DaysToSameDay = DAY(CurrentDate) - 1RETURN FirstDayOfNextMonth + DaysToSameDay*/&nbsp;Can someone please help me optimize these codes to get better DAX query performance

lbendlin · Answer

Are you familiar with DAX Studio?

pha · Answer

lbendlin&nbsp;I haven't used it but I can try. Please guide&nbsp;

lbendlin · Answer

Tutorials | DAX Studio

pha · Answer

Can anyone please help with simplifying the above DAX codes

lbendlin · Answer

Read about EDATE()

Forum Discussion

Related content

Query Exceeded Available Resource

visual has exceeded available resources

Query has exceeded available resources

query has exceeded to available resources

Visual has exceeded available resources