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 guys I am getiing an error as the only element in my list. Everything goes right untill the last step when i change it to list
let
Origen = Excel.Workbook(Web.Contents("https://.....xlsx"), null, true),
filtro_Sheet = Origen{[Item="cuenta",Kind="Sheet"]}[Data],
#"Encabezados promovidos" = Table.PromoteHeaders(filtro_Sheet, [PromoteAllScalars=true]),
#"Tipo cambiado" = Table.TransformColumnTypes(#"Encabezados promovidos",{{"cuenta", Int64.Type}}),
#"Duplicados quitados" = Table.Distinct(#"Tipo cambiado"),
Personalizado1 = Table.ToList(#"Duplicados quitados")
in
Personalizado1
Solved! Go to Solution.
Hi @Anonymous ,
Are the replies above helpful?
Best Regards,
Icey
@Icey Not that much. they were converting the number into text and I wanted to use th list as filter value and the column was numerical so what I did was to convert the other column to text so I can make the filter to work
Hello @Anonymous
change your last step to this
Table.ToList(#"Duplicados quitados",(x)=> Combiner.CombineTextByDelimiter(",")(List.Transform(x, each Text.From(_))))
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
When you click on the Error link it will add another step and tell you what went wrong. after you corrected that you can then remove the added step.
@lbendlin it says that it can not convert the value to text. I though I could store numbers in lists.
So is that the issue?
I don't think lists accept any datatype other than variant.
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.