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 ...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi IgorKaradzic 

I expected your last answer as I did not know what inputs are and at which level to provide calculated column works as you want.

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.

  • 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.

  • 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

    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