Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to Solution.
Column3 = IF(ISBLANK([Customer Parent ID]),[Customer ID],[Customer Parent ID])
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,
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,
Column3 = IF(ISBLANK([Customer Parent ID]),[Customer ID],[Customer Parent ID])
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
Thank you very much. It works
Rashid Anwar
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |