Concatenate 2 variables

[Eyal]

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

[amitchandak]

@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