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

Replace values based in a specific column

Hello guys,

 

I would like your help in something.

 

Lets say we have this table :

 

SellerId      SellerName        Amount

2000            Amazon               -100

2000                 A                       100

2001               Ebay                  -200

2001                 A                       200

2002               Aliexpress          -150

2002                 A                       150

 

i want to replace values based on a seller id..My desire output is below :

 

SellerId           SellerName                         Amount

2000                  Amazon                              -100

2000                  Amazon                                100

2001                   Ebay                                   -200

2001                   Ebay                                     200

2002                   Aliexpress                           -150

2002                   Aliexpress                             150

 

 

How can i implement this?

1 ACCEPTED SOLUTION

Accepted Solutions
HotChilli New Contributor
New Contributor

Re: Replace values based in a specific column

Duplicate the table and filter out the 'A' values so you get thisRenamed Sellers 2019-08-12 112513.png

Then do a 'Merge as New' with the original table (Inner Join on ID - Seller ID).

Expand the Table column.

Tidy data as required (remove  the original SellerName column)

1 REPLY 1
HotChilli New Contributor
New Contributor

Re: Replace values based in a specific column

Duplicate the table and filter out the 'A' values so you get thisRenamed Sellers 2019-08-12 112513.png

Then do a 'Merge as New' with the original table (Inner Join on ID - Seller ID).

Expand the Table column.

Tidy data as required (remove  the original SellerName column)

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 48 members 1,211 guests
Please welcome our newest community members: