Forum Discussion

yios's avatar
yios
Helper I
5 years ago

Dax calculated column optimization

Hi all,   I have created a calculated column with the below dax code Previous Val = var _date = MyTable[Date] var _label = MyTable[label] var _IssueDateTime = MyTable[IssueDateTime] return MA...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

yios , Try like this if it works better

 

MAXX(
FILTER(MyTable,
MyTable[label] = earlier(MyTable[label]) && MyTable[Date] = earlier(MyTable[Date]) && MyTable[IssueDateTime] < earlier(MyTable[IssueDateTime])),MyTable[ShipDateTime])