Forum Discussion
Solved
Adding a Row to a Query
I am working with some data from Google Analytics. Most of the information is easy to match up to our existing item table. The main exception is where we use branding in our advertising as this does ...
Hi,
I don't know if this will work for you, but you could give it a go...
In Power BI Desktop go to "Edit Queries" and select "Enter Data" to create a manual table. Create the new table with the sames columns as the table from Google Analytics and enter the missing data. After this you can Append the 2 queries.
Hi,
I don't know if this will work for you, but you could give it a go...
In Power BI Desktop go to "Edit Queries" and select "Enter Data" to create a manual table. Create the new table with the sames columns as the table from Google Analytics and enter the missing data. After this you can Append the 2 queries.
This is even more brilliant for its simplicity.
Thank you for pointing out what should have been an obvious route.
