Forum Discussion
IgorKaradzic
Helper I
Helper ICan' assign table elements to variables
Hi guys, i am trying to assign for example VAR test = 'Query1'[Field] but it doesn' work. Erorr is can't find name 'Field' but i know for a fact that it exists and i'm not spelling it wrong. Can ...
some_bih
Community Champion
Community ChampionHi IgorKaradzic
I understand that Task colum and column Planned Finish Date are critical input for new column NextDateForTask with definition below.
It could be that another column is key inputs as your simple example do not have some expected output.
Check it with your real data.
NextDateForTask =
--assuming Task is column criteria for max date
CALCULATE(
MAX(Sheet1[Planned Finish Date]),
ALLEXCEPT(Sheet1,Sheet1[Task])
)+1--adding one single date for start next task
Output
IgorKaradzicHelper I
Helper IHello, sorry for not answering earlier but this is still not the solution i am looking for. It's close but not it. Thank you for your help.