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 what is your request for possible solution: calculate something and also on your example table there is no [Field] (reference to your initial post: Query1'[Field] but it doesn' work. Erorr is can't find name 'Field' )

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?