Forum Discussion
Add Column to other table
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.
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?
How could I make the formula?
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])
but how do I take columns from two separate tables?
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.