Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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.
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.