LOAD * Inline [
Project, Phase, StartDate
Date(If(Project = Previous(Project), Previous(StartDate) - 1)) as EndDate
Order By Project, StartDate desc;
DROP Table Table;
Community_219617.qvw 150.5 K
I would create a key that contains the current Phase+1, and left join the table for itself.
The formula will be for -1 day is just simple =date(StartDate-1).
,Project & Phase+1 as Key
Project & Phase