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 probaj 

VAR test =SELECTEDVALUE('Query1'[Field])

 ili neku agregatnu kao MIN / MAX zavisno šta ti treba 🙂

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.