cancel
Showing results for
Did you mean:
Frequent Visitor

## How to combine one calculative column and one exiting column from same table?

Hello All ,

I have 1 table which is appended by  two other table.

on that table i  have one column A. , 2nd column B (  It is a calulative column ) and 3rd column C . please tell me how i'll get B and C into same column against A column .

A                   B      C

ahsdjddc        2      2

scjdjdec          3      3

Output should be

A                   B             C                 D

ahsdjddc       2              2                 2

scjdjdec         3              3                3

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: How to combine one calculative column and one exiting column from same table?

Add a new column in original table.

`D = 'Test Tb1'[B]`

Create a calculated table.

```Test Tb2 =
EXCEPT ( VALUES ( 'Test Tb1'[C] ), VALUES ( 'Test Tb1'[B] ) ),
"A", LOOKUPVALUE ( 'Test Tb1'[A], 'Test Tb1'[C], [C] )
)```

Union above two tables to get the result output.

```Test Tb3 =
UNION (
'Test Tb1',
SELECTCOLUMNS (
'Test Tb2',
"A", 'Test Tb2'[A],
"B", BLANK (),
"C", BLANK (),
"D", 'Test Tb2'[C]
)
)```

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Established Member

## Re: How to combine one calculative column and one exiting column from same table?

Try to add a calculated column

[column B]&[column C]

you can add space [column B]&" "&[column C] or similar.

Best regards

Highlighted
Frequent Visitor

## Re: How to combine one calculative column and one exiting column from same table?

@Floriankx it will concatenate ,i need B after C .... In one column

A                   B      C

ahsdjddc        2      2

scjdjdec          3      3

Output should be

A                   B             C               D

ahsdjddc       2              2               2

scjdjdec         3              3               3

Established Member

## Re: How to combine one calculative column and one exiting column from same table?

If you had the possibility to calculate the column in PowerQuery you could just add two additional columns (if you want to keep B and C) and unpivot them.

This would probably the easiest way.

Microsoft

## Re: How to combine one calculative column and one exiting column from same table?

Add a new column in original table.

`D = 'Test Tb1'[B]`

Create a calculated table.

```Test Tb2 =
EXCEPT ( VALUES ( 'Test Tb1'[C] ), VALUES ( 'Test Tb1'[B] ) ),
"A", LOOKUPVALUE ( 'Test Tb1'[A], 'Test Tb1'[C], [C] )
)```

Union above two tables to get the result output.

```Test Tb3 =
UNION (
'Test Tb1',
SELECTCOLUMNS (
'Test Tb2',
"A", 'Test Tb2'[A],
"B", BLANK (),
"C", BLANK (),
"D", 'Test Tb2'[C]
)
)```

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)