Using M query to obtain a value from table a, based on table b's contents

[JonSwed]

Hi all,

I have two tables where I want to obtain a value from table b, if values from table a match those in b.

I have a calculated column which does this:

Match from GA = LOOKUPVALUE(Google_Analytics_income[sessionCampaign], Google_Analytics_income[sessionCampaign], 'Email_date'[email_NAME])

This works, but my question is, what would the equivalent query look like in M? I would prefer to add this as an actual column in my data table.

Many thanks,
John.

[DataInsights · Accepted solution]

@JonSwed,

In Power Query, you can use Merge Queries to join the two tables, and return the column(s) you want from table B.