Google Analytics - Get unique Users across date range

[Anonymous]

Hi everyone,

From Google Analytics connectors, is there a way to get the total number of unique users for a date range?

I have imported the data by Date, but since users are unique in nature, I cannot jsut sum the total number of users by Date.

For example:

Date                Users

2019-01-01     500

2019-01-02     565

2019-01-03     879

However uers for date range  2019-01-01 to 2019-01-03 is 810.

Is there a way to handle this?

Thanks.

[stiggrr87]

Hi!
You need to take separate tables for separate time periods. If you want monthly stats then choose time/month from Google Cube (Google Analytics connector). If you need to take days then use time/date etc. 
But you cannot sum daily stats, because you will see wrong result.

You can confirm if this is correct when you check Google Analytics site

[v-yuezhe-msft]

@Anonymous,

There is a discussion in this similar thread about user measure of Google Analytics.

In your scenario, you might need to calculate unique users using DAX functions such as DISTINCTCOUNT().

Regards,
Lydia

[Anonymous]

Thanks @v-yuezhe-msft, 

The challenge is that google analytics do not provide the userid and hence you cannot use DistinctCount? 

Are there any other way to achive this?

Thanks

[v-yuezhe-msft]

@Anonymous ,

Please check adetogni's reply in that case. You might need to contact Google analytics support to check how to get an identify id to distinguish users. 

Regards,
Lydia

[Anonymous]

Hi @v-yuezhe-msft , 

Can you please show me the link for adetogni's  comment?

Thanks

[v-yuezhe-msft]

@Anonymous,

Please check the link below.

https://community.powerbi.com/t5/Desktop/user-measure-google-analytics/td-p/199791/page/2

Regards,
Lydia