Google Analytics: wrong cost after filtering

[Anonymous]

Kindly ask you to help me with my issue.

I am loading data from GA:

= Cube.Transform(#"182827499",
{
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddAndExpandDimensionColumn, "ga:campaign", {"ga:campaign"}, {"Campaign"}},
{Cube.AddMeasureColumn, "Cost", "ga:adCost"}
})

I filter table by date 11/1/2020 and get following data: (attention to the first line - cost 7.20) - this is proper cost, which I also see in google analytics page

11/1/2020	GDN_Brand_Underdog_Audience(keyword)_0022021	7.20
11/1/2020	GDN_CEO_Audience(keyword)_0013012	7.18
11/1/2020	GDN_Finance_2_0_Audience(keyword)_0072031	7.16
11/1/2020	GDN_Finplan_Retargeting_UA_0062032	0.15
11/1/2020	GDN_Marketing_core_Retargeting_UA_0042021	0.25
11/1/2020	GSP_Keys_ALL_0008005	4.23
11/1/2020	Retargeting_ALL_0008005	3.08
11/1/2020	Search_Brand_UA_0008005	0.08
11/1/2020	Search_Brand_Underdog_UA_0022021	0.01
11/1/2020	Search_Competitors_UA_0008005	0.09
11/1/2020	Social_All_Proudcts_0008005_SUPERLUDI_FriendsFollowers_Website	142.43
11/1/2020	Social_All_Proudcts_0008005_SUPERLUDI_Retargeting_Website	183.20
11/1/2020	Social_CEO_0013012_Interests_Website_CPA	148.85
11/1/2020	Social_Marketing-Core_0042021_Website_CPA	99.00
11/1/2020	Social_Prodigy-Finance_0072031_Interests_Website	65.51
11/1/2020	Social_digital_marketing_0052021_Interests_Website_CPA_v2	225.44

Then I paste any step before filtering. For example, duplicate one of the existing column. And after filtering by the same date 11/1/2020 you can see I get following data: (attention to the first line - cost 8.40) - this cost is wrong, it is bigger than the right one.

11/1/2020	GDN_Brand_Underdog_Audience(keyword)_0022021	8.40	GDN_Brand_Underdog_Audience(keyword)_0022021
11/1/2020	GDN_CEO_Audience(keyword)_0013012	8.38	GDN_CEO_Audience(keyword)_0013012
11/1/2020	GDN_Finance_2_0_Audience(keyword)_0072031	8.35	GDN_Finance_2_0_Audience(keyword)_0072031
11/1/2020	GDN_Finplan_Retargeting_UA_0062032	0.17	GDN_Finplan_Retargeting_UA_0062032
11/1/2020	GDN_Marketing_core_Retargeting_UA_0042021	0.29	GDN_Marketing_core_Retargeting_UA_0042021
11/1/2020	GSP_Keys_ALL_0008005	4.93	GSP_Keys_ALL_0008005
11/1/2020	Retargeting_ALL_0008005	3.60	Retargeting_ALL_0008005
11/1/2020	Search_Brand_UA_0008005	0.10	Search_Brand_UA_0008005
11/1/2020	Search_Brand_Underdog_UA_0022021	0.02	Search_Brand_Underdog_UA_0022021
11/1/2020	Search_Competitors_UA_0008005	0.10	Search_Competitors_UA_0008005
11/1/2020	Social_All_Proudcts_0008005_SUPERLUDI_FriendsFollowers_Website	142.43	Social_All_Proudcts_0008005_SUPERLUDI_FriendsFollowers_Website
11/1/2020	Social_All_Proudcts_0008005_SUPERLUDI_Retargeting_Website	183.20	Social_All_Proudcts_0008005_SUPERLUDI_Retargeting_Website
11/1/2020	Social_CEO_0013012_Interests_Website_CPA	148.85	Social_CEO_0013012_Interests_Website_CPA
11/1/2020	Social_Marketing-Core_0042021_Website_CPA	99.00	Social_Marketing-Core_0042021_Website_CPA
11/1/2020	Social_Prodigy-Finance_0072031_Interests_Website	65.51	Social_Prodigy-Finance_0072031_Interests_Website
11/1/2020	Social_digital_marketing_0052021_Interests_Website_CPA_v2	225.44	Social_digital_marketing_0052021_Interests_Website_CPA_v2

I realy can`t get what is the problem. Maybe the reason is that cost is MeasuredColumn, but how can I fix it?

[AllisonKennedy]

@Anonymous  What do you mean 'paste any step before filtering' ? Are you working in Power Query? Have you done a merge? This can often add extra rows if you're not careful and make your values increase unexpectedly. https://excelwithallison.blogspot.com/2020/10/merge-ahead-one-for-one.html