creating a new column using values from 2 columns of the same table

[rashid0146]

Hi All

I have two columns, one is customer ID and 2nd is Customer Parent. I need a 3rd column containg values from first and 2nd as shown below.

Customer ID        Customer Parent ID        3rd Column (I Want to Create in Power BI)

0001                     0010                                  0010

0002                                                               0002

0003                     0010                                  0010

0004                                                               0004

0005                     0011                                  0011

0006                                                               0006

0007                                                               0007

Regards

Rashid Anwar

[Greg_Deckler · Accepted solution]

Column3 = IF(ISBLANK([Customer Parent ID]),[Customer ID],[Customer Parent ID])

[v-sihou-msft · Accepted solution]

@rashid0146

You can use DAX to create a calculated column as @Greg_Deckler suggested.

This can also be achieved via Power Query:

= if [Column2] is null then [Column1] else [Column2]

Regards,

[Greg_Deckler · Accepted solution]

Column3 = IF(ISBLANK([Customer Parent ID]),[Customer ID],[Customer Parent ID])

[rashid0146]

Hi Smoupre

I applied your formula Column3 = IF(ISBLANK([Customer Parent ID]),[Customer ID],[Customer Parent ID]) but it is not picking the value for blak field. I mean it is giving the following results shown in 3rd column. One thing to note that source of data is SQL server. I guess ISBLANK function si not recognizing the Blank fields in Customer Parent ID table as blank that is why returning the results.

Customer ID        Customer Parent ID        3rd Column (I Want to Create in Power BI)
0001                     0010                                  0010
0002                                                              
0003                     0010                                  0010
0004                                                              
0005                     0011                                  0011
0006                                                              
0007                                                              

[rashid0146]

Thank you very much. It works

Rashid Anwar

[tnoflahc]

Greetings rashid0146,

This may be of some help to you:

http://community.powerbi.com/t5/Desktop/help-how-to-merge-2-columns/td-p/53920

This link is a blog post that has a little more background than just the process identified in the above link: 

https://businessintelligist.com/2015/09/15/power-bi-desktop-merge-query-options/

I hope this leads you to your solution.