Forum Discussion
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 ...
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!
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])