Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

very slow performance

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])
)   

 

 

Need Help

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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