Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
matheus_peppers
Frequent Visitor

What do I do when "Comma token expected" appears

Hi guys, I'm trying to copy some Applied Steps I did in one database, into another database in another file, but it's giving this error in one of the steps: "Comma token expected."

 

Can anyone help me?

 

The code is as follows:

 

let
    Fonte = Folder.Files("G:\Meu Drive\1. MUTUP\CLIENTES\Re.All\Base de Dados\Re.All\Meta Ads\GenderAge"),
    #"Outras Colunas Removidas" = Table.SelectColumns(Fonte,{"Content", "Name"}),
    #"Arquivos Ocultos Filtrados1" = Table.SelectRows(#"Outras Colunas Removidas", each [Attributes]?[Hidden]? <> true),
    #"Invocar Função Personalizada1" = Table.AddColumn(#"Arquivos Ocultos Filtrados1", "Transformar Arquivo", each #"Transformar Arquivo"([Content])),
    #"Outras Colunas Removidas1" = Table.SelectColumns(#"Invocar Função Personalizada1",{"Name", "Transformar Arquivo"}),
    #"Coluna de Tabela Expandida1" = Table.ExpandTableColumn(#"Outras Colunas Removidas1", "Transformar Arquivo", Table.ColumnNames(#"Transformar Arquivo"(#"Arquivo de Amostra")))
    #"Soma Inserida" = Table.AddColumn(#"Coluna de Tabela Expandida1", "Adição", each List.Sum({[Cadastrou sergiocamargo], [Cadastrou salveosanimaissilvestres], [Cadastrou kidbengala4469], [Cadastro Realizado], [Cadastrou lutepelavidaanimal], [Cadastro LutaPelosAnimaisSilvestres], [Cadastros na Meta], [Cadastros no site], [Cadastros]}), Int64.Type),
in
    #"Soma Inserida"

 

If anyone can help me, I thank you very much.

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

let
    Fonte = Folder.Files("G:\Meu Drive\1. MUTUP\CLIENTES\Re.All\Base de Dados\Re.All\Meta Ads\GenderAge"),
    #"Outras Colunas Removidas" = Table.SelectColumns(Fonte,{"Content", "Name"}),
    #"Arquivos Ocultos Filtrados1" = Table.SelectRows(#"Outras Colunas Removidas", each [Attributes]?[Hidden]? <> true),
    #"Invocar Função Personalizada1" = Table.AddColumn(#"Arquivos Ocultos Filtrados1", "Transformar Arquivo", each #"Transformar Arquivo"([Content])),
    #"Outras Colunas Removidas1" = Table.SelectColumns(#"Invocar Função Personalizada1",{"Name", "Transformar Arquivo"}),
    #"Coluna de Tabela Expandida1" = Table.ExpandTableColumn(#"Outras Colunas Removidas1", "Transformar Arquivo", Table.ColumnNames(#"Transformar Arquivo"(#"Arquivo de Amostra"))),
    #"Soma Inserida" = Table.AddColumn(#"Coluna de Tabela Expandida1", "Adição", each List.Sum({[Cadastrou sergiocamargo], [Cadastrou salveosanimaissilvestres], [Cadastrou kidbengala4469], [Cadastro Realizado], [Cadastrou lutepelavidaanimal], [Cadastro LutaPelosAnimaisSilvestres], [Cadastros na Meta], [Cadastros no site], [Cadastros]}), Int64.Type)
in
    #"Soma Inserida"

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Just remove the comma at the end of the line before the "in" step, and add a comma at the end of the line before your last line.

 

--Nate

wdx223_Daniel
Super User
Super User

let
    Fonte = Folder.Files("G:\Meu Drive\1. MUTUP\CLIENTES\Re.All\Base de Dados\Re.All\Meta Ads\GenderAge"),
    #"Outras Colunas Removidas" = Table.SelectColumns(Fonte,{"Content", "Name"}),
    #"Arquivos Ocultos Filtrados1" = Table.SelectRows(#"Outras Colunas Removidas", each [Attributes]?[Hidden]? <> true),
    #"Invocar Função Personalizada1" = Table.AddColumn(#"Arquivos Ocultos Filtrados1", "Transformar Arquivo", each #"Transformar Arquivo"([Content])),
    #"Outras Colunas Removidas1" = Table.SelectColumns(#"Invocar Função Personalizada1",{"Name", "Transformar Arquivo"}),
    #"Coluna de Tabela Expandida1" = Table.ExpandTableColumn(#"Outras Colunas Removidas1", "Transformar Arquivo", Table.ColumnNames(#"Transformar Arquivo"(#"Arquivo de Amostra"))),
    #"Soma Inserida" = Table.AddColumn(#"Coluna de Tabela Expandida1", "Adição", each List.Sum({[Cadastrou sergiocamargo], [Cadastrou salveosanimaissilvestres], [Cadastrou kidbengala4469], [Cadastro Realizado], [Cadastrou lutepelavidaanimal], [Cadastro LutaPelosAnimaisSilvestres], [Cadastros na Meta], [Cadastros no site], [Cadastros]}), Int64.Type)
in
    #"Soma Inserida"

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors