The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
User | Count |
---|---|
83 | |
83 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
61 | |
51 | |
51 |