Forum Discussion
Anonymous
6 years agoNot applicable
Use a variable in a calculated column
Hi, so I created a column that display "true" or "false" if the conditions are matching. I would like to know if there is a way to create a variable, X=757_501, for example, and replace ...
- 6 years ago
YES you can use veriables in dax
for example
Query Bugs = Var T = "787_501" Var ret = <put your dax here and replace each instance on text with T> Return ret
Where you need to combine your veriable in a string just use a &
fore example where you have "test 787_501" replace with "test " & T
AnthonyTilley
6 years agoSolution Sage
YES you can use veriables in dax
for example
Query Bugs = Var T = "787_501" Var ret = <put your dax here and replace each instance on text with T> Return ret
Where you need to combine your veriable in a string just use a &
fore example where you have "test 787_501" replace with "test " & T
Anonymous
6 years agoNot applicable
The answer was under my eyes since the beginning, you can't even imagine every things I tried knowing this VAR function...
Thanks