Combining 3 measures (3 columns) in one column

[Anonymous]

Hi

I have 3 measures: [Cover_Wk0],[Cover_Wk1],[Cover_Wk2] and I'd like to combine all of them in one column. 

have tried the method below but is failing stating that multiple columns cannot be convert to a scalar value.

Combine:=UNION (
ADDCOLUMNS ( IBPData1, "Cover_Wk0", [Cover_Wk0] ),
ADDCOLUMNS ( IBPData1, "Cover_Wk1", [Cover_Wk1] ),
ADDCOLUMNS ( IBPData1, "Cover_Wk2", [Cover_Wk2] )
)

Any suggestions?

Cheers,

Gilly

[v-lili6-msft]

hi, @Anonymous 

You could just use CONCATENATE Function to get it as below:

Combining = CONCATENATE( CONCATENATE([Measure],[Measure 2]),[Measure 3])

Result:

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft ,

Thank you for replying, actually I didn't stated correctly, what I need is to unpivot these 3 measures and tranpose them in one column.

Regards,

Gilly

[v-lili6-msft]

hi, @Anonymous 

If this is what you want?

Combining = [Measure]&UNICHAR(10)&[Measure 2]&UNICHAR(10)&[Measure 3]

Result:

Best Regards,

Lin

[Anonymous]

Correct @v-lili6-msft , transpose from different columns to one column

[v-lili6-msft]

hi, @Anonymous 

Do you want to the three measure show in different cell in a column?

If so, it couldn't achieve, for measure is based on the current row context.

Best Regards,

Lin