Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
  • AnthonyTilley's avatar
    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