Add Column to other table

[jracer007]

Hello community,

How can I add these two columns (Page and Total Events)to another table?

Note: the data source is from Google Analytics.

[v-chuncz-msft]

@jracer007,

Based on the above, you may use Merge Queries in Query Editor.

[Greg_Deckler]

Depends. You could just reimport the information you want (copy your query(ies)).

Or, you could use something like SUMMARIZE or ADDCOLUMNS to create a new table in your data model.

Not entirely sure what you are asking. Are these two separate tables and if so, how are they related?

[jracer007]

How could I make the formula?

[Greg_Deckler]

So, you could just go to the Modeling tab you can choose New Table. Then you can put in a formula like:

Table = SUMMARIZE(Table,[Page],"Events",[Total Events])

[jracer007]

but how do I take columns from two separate tables?

[Greg_Deckler · Accepted solution]

This is the part of your message that is not clear. You mention Pages and Total Events which seem like they are part of the same table. You can use UNION to mash tables together or NATURALINNERJOIN. But, I still doin't have a good understanding of the output that you want exactly.

[jracer007]

they are not related, and those are the tables are separate.