very slow performance

[Anonymous]

i am facing performance issue in the above dax in live connection. can anyone modify the formulae to make the dax efficient.if i don't add customer number and Item name to the table then dax is working perfectly. but when i try to put the customer number and Item in the table it is not loading.

previousSCDate = 
Var MaxPlanDate = CALCULATE(Max(date[CreatedDate]),GROUPBY(Cus,[Cus_Number]),GROUPBY('item',[itemname]))
Return
  CALCULATE(
    MAX(date[CreatedDate] )
   ,date[CreatedDate] < MaxPlanDate,GROUPBY(Cus,[Cus_Number]),GROUPBY('item',[itemname])
)   

[v-lili6-msft]

hi, @Anonymous 

If you could filter some data and then try it again?

or if you just use this formula to create a measure

Measure 3 = CALCULATE(MAX('date'[CreatedDate]),FILTER(ALL('date'),'date'[CreatedDate]<MAX('date'[CreatedDate])))

If possible, could you share some sample data and your expected output.

Best Regards,

Lin