Forum Discussion

iplaygod's avatar
iplaygod
Resolver I
7 years ago
Solved

DAX: How update a variable value after having defined the variable?

I am writing DAX

In most other coding languages, I can define a variable, give it a value, and then later on in the code change or add to that value.
Eg:

VAR myVariable = 1
//later in the code:
myVariable = 2

Is this possible in DAX?
Or can I only set variable values when I define them with the VAR statement?

I want to concatenate strings by adding them onto a string variable.
I can not use CONCATENATEX in this situation.

So I want to do
VAR concatString = ""

//then later in the code
concatString = concatString & "|" & newValue

is this possible? please give me example code if it is.

Also, a sidenote question:
What happens if I re-define a variable with the same name?
Do I then "wipe out" the previous variable with the same variable name?

thanks in advance

Need Help

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi iplaygod,

     

    I don't think we can re-define a variable with the same name. 

     

    If you want to achieve below formula
    VAR concatString = ""

    //then later in the code
    concatString = concatString & "|" & newValue

     

    You may need to define two different variables like this:

    VAR concatString = ""
    VAR concatString2 = concatString & "|" & newValue

     

    Best regards,

    Yuliana Gu

    • iplaygod's avatar
      iplaygod
      Resolver I
      7 years ago

      ok thanks

      so follow-up question...

       

      is it possible to create a variable and naming it by using a string?

      like in Power Query (M) language you can use

      #"myVariable"

       

      is there a similar alternate syntax for defining / naming variables in DAX?