Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
99 | |
70 | |
44 | |
38 | |
29 |
User | Count |
---|---|
156 | |
92 | |
61 | |
44 | |
42 |