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

That's what is says in error message. I sent you example table down bellow.

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

ID Task Responsible

Planned Start Date

Planned Finish Date

1

13.3.2024.

23.3.2024.

2

23.3.2024.

25.3.2024.

2

25.3.2024.

1.4.2024.

2

25.3.2024.

29.3.2024.

2

29.3.2024.

7.4.2024.

2

7.4.2024.

10.4.2024.

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

    Hi IgorKaradzic I am sorry, I do not understand your issue based on information from your side.

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

      First i would like to compare data from column ID Task Responsible. First row from that column with second row, then second row with third row and so on. If they are not equal then do nothing. If they are equal, we must check if there is overlaping in dates. If there is, then i must for example add 5 hours to second compared row. We must do that for each 2 rows like i mentioned. Is it possible to do something like that? 

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

        Hi IgorKaradzic "comparing" row by row for same column could be tricky as you have same (not unique) in column ID.

        Why don't you use column Planned Finish Date in your calculation logic, if possible?