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

Nazalost, ni ovo ne radi. Sad pored inicijalnog errora pokazuje i nov tip errora da parametar nije odgovarajuceg tipa. Zaboravio sam da napomenem da je Field polje tekstualni tip.

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

Hi / pozdrav IgorKaradzic 

We need more details about your model / tables / relationships between tables and columns and when you plan to use this field, to provide some possible solution.

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

    My overall goal with this task is to compare task id's inside same column and if the are the same check if time for the tasks overlap. They are in Month, Date, Year format.

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

      Here is example table

       

      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.