Forum Discussion

Daxtothemax's avatar
Daxtothemax
Icon for Helper I rankHelper I
4 years ago

Previous Task ID Value IF Less Than

Looking for a DAX formula that would know if the previous day duration was less than the current day duration (meaning the duration increased). If it was true then take the previous day duration, if ...
Need Help
Daxtothemax's avatar
Daxtothemax
Icon for Helper I rankHelper I
4 years ago

Hi ryan_mayu 

Thank you, this works but the tasks can have multiple increases in Durations.  So I need the formula to reference the original first duration listed not just the previous date duration.  Any ideas? Thanks again!

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

Daxtothemax 

is this what you want?

Column = 
var _first=minx(FILTER('Table','Table'[date]<=EARLIER('Table'[date])&&'Table'[taskid]=EARLIER('Table'[taskid])),'Table'[date])
return maxx(FILTER('Table','Table'[taskid]=EARLIER('Table'[taskid])&&'Table'[date]=_first),'Table'[remaining duration])