Group by Duration problem

[efilipe]

Hi guys, 

I'm having a problem here.

I have 3 columns, date, video_id, event_action and time_watched that I get from Google Analytics integration.

I want to Group by Date and Video ID and sum duration. So Event column should go away.

Just to make a test and validate the numbers comparing to GA, I'm also removing the video_id column to se the total for the day.

And I filter after for the date 07/03/2020 I get this value:

 

But this result doesnt match whats in Google Analytics.

But, if I do it differently. If I filter the date I want to validate with GA first, before doing a group by:

And then do a group By:

I get a different result. The RIGHT result.

I'm going crazy here. What am I doing wrong?? 🙂

[Anonymous]

@efilipe 

This is strange, both should get a same result. Is is possible to share the data or a sample that has the same issue.

Best regards

Paul Zheng

[efilipe]

Hello, @Anonymous and @az38 

I recorded a small video. Can you guys watch?

https://we.tl/t-c0IzrrIQTb

Thanks!

[az38]

@efilipe 

in this video demonstrated work in ONLY Power QUery editor which is the PREVIEW of data as I told you before.

Press Close & Apply and check your data in the both workarounds

[Anonymous]

Like @az38 said I have done testing with my data and it works fine. Either way got the same results.

Did I answer your question? If Yes, Give me a Kudo

[az38]

Hi @efilipe 

do you check the data in Power Query mode or Report mode?

Power query displays only review of data and may not be up to date

[efilipe]

Shows the wrong number in the dashboard.

Thanks

[efilipe]

@amitchandak maybe you know the answer? 🙂

[az38]

@efilipe 

Ive done with my sample data and it works as expected.

could you share your pbix-file after remove all sensitive data?