Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I'm trying to create a tabel from a list. The list was created from two values (dates converted into number), but when I try to create the table I get a error. More details bellow:
Power Query Script where the error is launched:
let
#"Cria Lista Datas" = {Number.From(PARAM_MIN_DATA_OCORRENCIA) .. Number.From(Date.From(DateTime.LocalNow()))},
#"Cria tabela da lista" = Table.FromList(#"Cria Lista Datas")
in
#"Cria tabela da lista"
PARAM_MIN_DATA_OCORRENCIA is a Date value calculated in another Query. It's working fine, but if you wish it an be replaced by "01/10/2012" and the error will be lauched any way.
Could any one say if I'm doing something wrong or if it's Power Query bug?
Solved! Go to Solution.
Hi @trt18-sistemas ,
By default items in the list are separated by comma.
Try this:
Table.FromList(#"Cria Lista Datas", Splitter.SplitByNothing())
Hi @trt18-sistemas ,
By default items in the list are separated by comma.
Try this:
Table.FromList(#"Cria Lista Datas", Splitter.SplitByNothing())