Forum Discussion
ldwf
Helper V
Helper VDAX Formula
Need help with a DAX formula. I have a result set that has the five columns as shown in the image. The number of records is much larger, and there are multiple dates and statuses. I need to create...
Hi,
Try this
Latest due date = calculate(max(Data[Due date]),filter(Data,Data[Date]=earlier(Data[Date])&&Data[Status]=earlier(Data[status])&&Data[Volume]>0))
ldwfHelper V
Helper VI rephrased the question. The DAX formula needs a filter as well
Ashish_Mathur
Super User
Super UserHi,
Try this
Latest due date = calculate(max(Data[Due date]),filter(Data,Data[Date]=earlier(Data[Date])&&Data[Status]=earlier(Data[status])&&Data[Volume]>0))
- ldwfThat worked!...thanks