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 worki...
Need Help
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