Use a variable in a calculated column

[Anonymous]

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 !

[amitchandak]

Use VAR to create variable and use substitute to replace value 

Sample how 

YTD Sales = 
Var var= "XYX"
Return
 substitute()......

[AnthonyTilley · Accepted solution]

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]

The answer was under my eyes since the beginning, you can't even imagine every things I tried knowing this VAR function...
Thanks