Set Google Adword Costs in currency

[nwanko]

Hi all,

I connect Power BI with Google Analytics to get Adword data, I fetch the costs per week of the year. I get the data through 7 queries from individual accounts (Google data per label) which I want to combine. However the costs per label are all in local currency. Anyone a suggestion how to extract all the data in EURO? When I make a report within Google Adwords this happens automatically... Can I add a tag after "ga:adCost"?

let
Bron = GoogleAnalytics.Accounts(),
#"XXXXX" = Bron{[Id="XXXXX"]}[Data],
#"UA-XXXX" = #"XXXXX"{[Id="UA-XXXXXXX"]}[Data],
#"YYYYYY" = #"UA-XXXXXX"{[Id="YYYYYYYY"]}[Data],
#"Added Items" = Cube.Transform(#"YYYYYYY",
{
{Cube.AddAndExpandDimensionColumn, "ga:yearWeek", {"ga:yearWeek"}, {"Week of Year"}},
{Cube.AddMeasureColumn, "Cost", "ga:adCost"}
}),
#"Added Custom" = Table.AddColumn(#"Added Items", "Label", each "website_name.no")
in
#"Added Custom"

[dax]

Hi @nwanko , 

As I know, there is no currrency type in Change Type, you could try to convert the number typr to Europe Type , then add a currency symbol.

Or you could change this in Design pane like below

 Or you also could try Currency.From to see whether it work or not. You could refer to currency-from  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nwanko]

Many thanks @Zoe Zhi!

I think you refer to adding symbols in Power BI but do you think this could result in converted currencies (I want to convert various currencies all to euro)? Any experience in forcing Google Analytics to supply a specific currency (instead of the main currency of the Google account?)