Forum Discussion
Calculations from different data sources
Hello,
I would like to bring together data from Google Analytics and a Google Spreadsheet and put it into a calculation so that, for example, I can calculate the revenue per user of the website. How can this best be done with Power BI?
Greetings,
Max.
2 Replies
Hi seimax
First of all, you need to connect to Google Analytics and Google Spreadsheet.
How to connect google sheet to Power BI
Google Analytics connector for Power BI Desktop
Then you may need to shape data to meet your requirements.
Tutorial: Shape and combine data in Power BI Desktop
Tutorial: Analyze web page data using Power BI Desktop (Google Spreadsheet can be considered as a web page data)
Next try to create relationship between two dataset, then create calculated columns or measures to use the data from different tables.
Tutorial: Create calculated columns in Power BI Desktop
Tutorial: Create your own measures in Power BI Desktop
Best Regards
Maggie
Create and manage relationships in Power BI Desktop
Hi Maggie,
many many thanks for your answer. Does this process also works with the Power BI Cloud App?
Best regards from Cologne,
Max.
