how to update a column based on the value of a different table value

[Wolly]

I have two tables.  

One table has the stock price info:

TABLE1

Stock.         Ticker.    Price

Google.      Googl.   XXXX

Mastercard.  MA     YYYY

TABLE2 just has:

Ticker.   Price.

MA.        ????

How would i update the 2nd table to place the value "YYYY" in Price column?

[Wolly]

Is what I'm asking not doable? Ie to do it in Power Query?

[CoreyP]

Just use Merge Queries in Power Query. Select the common field to merge on, which in your example is Ticker. Then in your merged queries, create a new conditional column. If Table2[Price] is null then Table1[Price] else Table2[Price]. 

[Ahmedx]

if you have abbreviated names in the Ticker column in the second table, then you need this measure

[Wolly]

This is in DAX.  How would i do it in a powerquery?  

I simplified the ask in original post.  But background: Table1 represents one account that has current market price information.  Table2 represents a second set of accounts that has stale price data, so i want to use Table1 as a reference.  Once Table2 is updated, I'd like to merge the two tables to get a consolidated table of accounts with all columns populated and up to date.

[ryan_mayu]

@Wolly 

is this what you want?

Column = maxx(FILTER(Table1,Table1[Ticker]=Table2[Ticker]),Table1[Price])

[Wolly]

This is in DAX.  How would i do it in a powerquery?  

I simplified the ask in original post.  But background: Table1 represents one account that has current market price information.  Table2 represents a second set of accounts that has stale price data, so i want to use Table1 as a reference.  Once Table2 is updated, I'd like to merge the two tables to get a consolidated table of accounts with all columns populated and up to date.

[ryan_mayu · Accepted solution]

@Wolly 

try to merge two tables

[CoreyP]

There are several ways you could do this, the best method depends on the specific context of your data model. Why are these two tables separate? Are they showing different things or for different time periods? In any case, you can either merge the tables in Power Query. Or you can create a dimension table for stocks that would include the ticker symbol. Then create a relationship to both tables from this dimension. 

[Wolly]

I'm looking to do this in a power query.  I simplified the task.  Table1 represents one account that has current market price information.  Table2 represents a second set of accounts that has stale price data, so i want to use Table1 as a reference.  Once Table2 is updated, I'd like to merge the two tables to get a consolidated table of accounts with all columns populated and up to date.