Friday, February 28, 2025

Power Query - fnc funcao Date

   #"Changed column type" = Table.TransformColumnTypes(#"Renamed columns2", {{"INÍCIO DO ANO LETIVO", Int64.Type}, {"INÍCIO DO RECESSO", Int64.Type}, {"FIM DO ANO LETIVO", Int64.Type}, {"FIM DO RECESSO", Int64.Type}}),

  #"Lowercased text" = Table.TransformColumns(#"Changed column type", {{"INÍCIO DO ANO LETIVO", each Date.AddDays(DataBase, Number.FromText(Text.From(_))), type date}}),
  #"Lowercased text 1" = Table.TransformColumns(#"Lowercased text", {{"INÍCIO DO RECESSO",  each Date.AddDays(DataBase, Number.FromText(Text.From(_))), type date}}),
  #"Lowercased text 2" = Table.TransformColumns(#"Lowercased text 1", {{"FIM DO ANO LETIVO",  each Date.AddDays(DataBase, Number.FromText(Text.From(_))), type date}}),
  #"Lowercased text 3" = Table.TransformColumns(#"Lowercased text 2", {{"FIM DO RECESSO",  each Date.AddDays(DataBase, Number.FromText(Text.From(_))), type date}})
in
  #"Lowercased text 3"

Power Query - funcao limpa replace texto numero

//fnc_limpa_texto (TextValue as nullable text) => let     SafeText = if TextValue = null then "" else TextValue,     DigitsOnly...