Forum Discussion

seimax's avatar
seimax
New Member
8 years ago

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. H...
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

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.

Query editor

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

 

 

  • seimax's avatar
    seimax
    New Member
    8 years ago

    Hi Maggie,

     

    many many thanks for your answer. Does this process also works with the Power BI Cloud App?

     

    Best regards from Cologne,
    Max.