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.