This is from the Coursera Power BI course. I'm trying to create a create a "Sales in USD" calculated table. I was instructed to select a New Table in Power BI and type the following:
Sales in USD =
ADDCOLUMNS(
Sales,
"Country Name", RELATED(Countries[Country]),
"Exchange Rate", RELATED('Exchange Data'[Exchange Rate]),
"Exchange Currency", RELATED('Exchange Data'[Exchange Currency]),
"Gross Revenue USD", [Gross Revenue] * RELATED('Exchange Data'[Exchange Rate]),
"Net Revenue USD", [Net Revenue] * RELATED('Exchange Data'[Exchange Rate]),
"Total Tax USD", [Total Tax] * RELATED('Exchange Data'[Exchange Rate])
)
It generated "The following syntax error occurred during parsing: Invalid token, Line 3, Offset 2, ."
I've looked online for how the ADDCOLUMNS function is used, and the code above seemed to comport with the explanations that I read online.
What am I - I mean Coursera - doing wrong?