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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
angelorauber
New Member

Convertion Value error on Text.Combine function

Olá,

 

     Estou preparando uma consulta com parâmetro de entrada de tabela do Excel para o Power Query. Criei a coluna customizada concatenando os dados. Porém quando vou usar a função Text.Combine, acusa o erro:

------------------------------------------------------------------------------------------

Expression.Error: Não conseguimos converter o valor "f.datadm between '01..." em tipo List.
Detalhes:
Value=f.datadm between '01/01/1900 00:00:00' and '31/12/2500 23:59:59'
and f.numemp in (1,2,3)
order by 1,3,5,6
Type=[Type]

 

Criação da nova coluna concatenada:

--------------------------------------------------------------------------------

= Table.AddColumn(#"Tipo Alterado", "Custom", each "f.datadm between '"&[#"Admissão (DE)"]&"' and '"&[#"Admissão (ATÉ)"]&"'
and f.numemp in ("&[Empresa]&")
order by 1,3,5,6")

 

--------------------------------------------------------------------------------

Conteúdo da Coluna concatenada:

--------------------------------------------------------------------------------

f.datadm between '01/01/1900 00:00:00' and '31/12/2500 23:59:59'
and f.numemp in (1,2,3)
order by 1,3,5,6

 

Função utilizada:

--------------------------------------------------------------------------------

= " and "&Text.Combine(#"Personalização Adicionada"{0}[Custom])

 

Se puderem me ajudar.

 

Primeira vez que estou utilizando

 

Muito obrigado.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

and f.numemp in (" & Text.Combine([Empresa],",") & ")

 

between '01/01/1900 00:00:00' and '31/12/2500 23:59:59'

Please don't do that.  Use realistic dates, or leave them blank.  You are adding millions of rows of data to your data model for no reason.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

and f.numemp in (" & Text.Combine([Empresa],",") & ")

 

between '01/01/1900 00:00:00' and '31/12/2500 23:59:59'

Please don't do that.  Use realistic dates, or leave them blank.  You are adding millions of rows of data to your data model for no reason.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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