Forum Discussion
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 every "787_501" by this X in my formula. I would like to do this because I might often want to change this number in the future. And changing the value of 1 variable is faster than changing it 15 times in a formula.
I tried to do this through measures but it didn't work as planned
Thanks !
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
3 Replies
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
Use VAR to create variable and use substitute to replace value
Sample how
YTD Sales = Var var= "XYX" Return substitute()......
