Friday, June 5, 2020

Power Query - Dynamic & bulk change type

= Table.TransformColumnTypes(Source,List.Transform(List.RemoveFirstN(Table.ColumnNames(Source),2),each {_, type number}))
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL - Query Analytics Basic

  SELECT Nome_Produto, ROUND(MIN(Valor_Venda), 2) AS Valor_Minimo, ROUND(MAX(Valor_Venda), 2) AS Valor_Maximo, ROUND(AV...