Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
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
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |