Tuesday, September 8, 2020

Power Query - Valid Text

   Step20 = Table.AddColumn(#"Changed column type", ".CustValidNum", each if Text.Length([CUST_SALES])=Text.Length(Text.Select([CUST_SALES],List.Transform({0..9},each Number.ToText(_)))) then "V" else "I"),

  Step21 = Table.SelectRows(Step20, each [#".CustValidNum"] = "V"),

  Step22 = Table.TransformColumnTypes(Step21, {{"CUST_SALES", Int64.Type}})

in

  Step22






-

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...