cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Marsbar Frequent Visitor
Frequent Visitor

Creating a new column with unduplicated values

I have a table that I am trying to keep all of the CC Row IDs but want to replace everything but the first value in Booking ID and GTR columns by Row ID with a zero (see table below). Any ideas on how I can accomplish this? 

I would really appreciate some guidance on how to possibly tackle this issue Capture.PNG

2 REPLIES 2
Super User
Super User

Re: Creating a new column with unduplicated values

@Marsbar this can be achieved in power query, bit hard to explain here, if you can share sample data in excel file and can get you the solution.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Marsbar Frequent Visitor
Frequent Visitor

Re: Creating a new column with unduplicated values

Not really sure how to attach an excel file, but here is sample data set that would be relatively easy to recreate and use to build a query I think 

Capture.PNGIdeally, I am looking for the three rows of 10EDW, 2 rows of 12MWA, and single rows of 17ZJB and 61YTR to be kept, but the booking ID and revenue to show for the first row of 10EDW, etc. 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 276 members 2,752 guests
Please welcome our newest community members: