cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
singhpratiksha8 Frequent Visitor
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

addchdj         1      4

ahsdjddc        2      2

scjdjdec          3      3

 

Output should be

 

A                   B             C                 D

addchdj        1              4                 1

ahsdjddc       2              2                 2

scjdjdec         3              3                3

addchdj        null        null               4

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-yulgu-msft
Microsoft

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

Hi @singhpratiksha8,

 

Add a new column in original table.

D = 'Test Tb1'[B]

1.PNG

 

Create a calculated table.

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

2.PNG

 

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]
    )
)

3.PNG

 

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.

View solution in original post

4 REPLIES 4
Floriankx Established Member
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
singhpratiksha8 Frequent Visitor
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

addchdj         1      4

ahsdjddc        2      2

scjdjdec          3      3

 

Output should be

 

A                   B             C               D

addchdj        1              4               1

ahsdjddc       2              2               2

scjdjdec         3              3               3

addchdj        null        null              4

Floriankx Established Member
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 v-yulgu-msft
Microsoft

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

Hi @singhpratiksha8,

 

Add a new column in original table.

D = 'Test Tb1'[B]

1.PNG

 

Create a calculated table.

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

2.PNG

 

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]
    )
)

3.PNG

 

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.

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

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

Difinity Conference

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

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)