Forum Discussion

IgorKaradzic's avatar
IgorKaradzic
Icon for Helper I rankHelper I
2 years ago

Can' 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 ...
IgorKaradzic's avatar
IgorKaradzic
Icon for Helper I rankHelper I
2 years ago

Like i said in the last reply, you were close. Instead of increasing next start date by +1 for every row separately, what should be done is based on previous row end date increase current row start date by previous row end date + 1.

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi IgorKaradzic 

Check definition for column PreviousRowEndDate

PreviousRowEndDate =
//calculation based on ID Task and Finish Date
VAR __idtask_responsible=Sheet1[ID Task Responsible]
VAR __task=Sheet1[Task]
VAR __date_of_planned_finish=Sheet1[Planned Finish Date]
VAR __calculation =
        CALCULATE(
            MAX(Sheet1[Planned Finish Date]),
            FILTER(Sheet1,
                Sheet1[ID Task Responsible]=__idtask_responsible && Sheet1[Planned Finish Date] < __date_of_planned_finish
            )
        )
VAR Result= IF(__calculation = BLANK(), Sheet1[Planned Finish Date], __calculation+1)
//in Result adding 1 day
RETURN Result

 

  • IgorKaradzic's avatar
    IgorKaradzic
    Icon for Helper I rankHelper I
    2 years ago

    Got it, thank you for your help regardless. Sorry i wans't able to convey my message in simpler way.

  • IgorKaradzic's avatar
    IgorKaradzic
    Icon for Helper I rankHelper I
    2 years ago

    I know you are trying your best to help me but looks like i don't know how to explain the end goal of this so i will send you table which i want as a result and yu tell me if it's possible to do it. We compare each 2 tasks, for example task 1 with task 2 and nothing changes etween them because their id's are different, task 1 with task 2, same id's and we can see that task 1 end date is same as task 2 start date so we need to move task 2 start date by task 1 end date + 1 and also move task 2 end date too. And we do that for task 2 with task 3 etc.

     

    ID Task Responsible

    Task

    Planned Start Date

    Planned Finish Date

    1

    Task1

    13.3.2024.

    23.3.2024.

    2

    Task2

    23.3.2024.

    25.3.2024.

    2

    Task3

    25.3.2024.

    1.4.2024.

    2

    Task4

    25.3.2024.

    29.3.2024.

    2

    Task5

    29.3.2024.

    7.4.2024.

    2

    Task6

    7.4.2024.

    10.4.2024.

    Actual Start Date

    Actual Finish Date

    13.3.2024.

    23.3.2024.

    23.3.2024.

    25.3.2024.

    26.3.2024.

    2.4.2024.

    3.4.2024.

    7.3.2024.

    8.4.2024.

    17.4.2024.

    18.4.2024.

    21.4.2024.

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi IgorKaradzic 

    I could not follow your logic. Maybe somebody else could help you