Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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())
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.