'Adding a Date Filter to Google Analytics Advanced Editor in Power BI
I am trying to pull in data from GA into Power BI. However, I am wanting to filter the data BEFORE it comes in. If I use the Transform data tool in Power BI, I am still getting multiple numbers.
Goal is to get Number of Sessions by Day by Channel. However, when I pull it by day, I am getting User X on Day 1, then again on Day 2, and again on Day 5. So they are showing up 3 times, rather than just 1 user.
Is there a way to apply a filter in the Advnaced Editor? Really appreciate the help.
let
Source = GoogleAnalytics.Accounts(),
#"40750267" = Source{[Id="40750267"]}[Data],
#"UA-40750267-11" = #"40750267"{[Id="UA-40750267-11"]}[Data],
#"238041331" = #"UA-40750267-11"{[Id="238041331"]}[Data],
#"Added Items" = Cube.Transform(#"238041331",
{
{Cube.AddAndExpandDimensionColumn, "ga:channelGrouping", {"ga:channelGrouping"},
{"Default Channel Grouping"}},
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddMeasureColumn, "Bounces", "ga:bounces"},
{Cube.AddMeasureColumn, "Sessions", "ga:sessions"},
{Cube.AddMeasureColumn, "Users", "ga:users"}
})
in
#"Added Items"
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
