Forum Discussion

Eyal's avatar
Eyal
Icon for Helper II rankHelper II
5 years ago

Concatenate 2 variables

Dear all

I have a foramting problem i just can find a solution.
I want to dispay in a table concatenated results of 2 or more variables.

the end result shloud be x.xx±y.yy
this is my measure:

 
AVG(±StDev) =
var A = ROUND(AVERAGE('BR Data'[Value]),2)
var S = ROUND(STDEV.P('BR Data'[Value]),2)

var result = A&"±"&S
Return

all i get is just he ± in every cell
any
result
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Eyal , Can check to you have any measure or column with name A and S

     

    Also, check the value of variable A and S might be blank

     

    AVG(±StDev) =
    var _A = ROUND(AVERAGE('BR Data'[Value]),2)
    var _S = ROUND(STDEV.P('BR Data'[Value]),2)

    Return
    _A & "±" & _S