Forum Discussion
undefined
Hi caruso1058 - see this measure:
Finish Date = VAR varCurrentDate = MAX('Table'[Start_Date]) VAR varNextDate = CALCULATE( MIN('Table'[Start_Date]), FILTER( All('Table'), 'Table'[Start_Date] > varCurrentDate ) ) RETURN IF( ISBLANK(varNextDate), varCurrentDate, varNextDate )This will return the minium date above the current date, unless there is no next date, in which case it will repeat the current date.
One note caruso1058 - you didn't specify, but I assume you want this to be by project. Note the replacement of ALL() with ALLEXCEPT()
So you can see that the April 1, 2020 date did not impact the A123 project.
Hi,
Try this calculated column formula
=calculate(min(data[project schedule]),filter(data,data[project]=earlier(data[project])&&data[project schedule]>earlier(data[project schedule])))
Hope this helps.
Hello edhans ,
Thank you very much for your help with this! I like your tactic, but I seem to be running into an issue with this logic, as it only returns the MAX Date within my dataset...seems to be a typo as we are not scheduling ahead that far in the future just yet, but I digress.
Anyway, the trouble I am having is two fold, one is extracting the last task date, second is grouping this logic by each project.
Hi,
Try this calculated column formula
=calculate(min(data[project schedule]),filter(data,data[project]=earlier(data[project])&&data[project schedule]>earlier(data[project schedule])))
Hope this helps.
Ashish_Mathur,
That works perfectly as a calculated column! Thank you very much!You are welcome.