Forum Discussion

ErisedAlurem's avatar
ErisedAlurem
Frequent Visitor
4 years ago
Solved

Expression.Error: We cannot apply field access to the type Text

Hello everyone! I need some help with an if statement in power query. The formula I'm using currently is as shown below:     #"Extracted Text After Delimiter" = Table.TransformColumns(#"change2",...
  • CNENFRNL's avatar
    4 years ago
    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("rZI5bsMwEEWvEqi2iNk4w6XKAtcp1AkuhEAIXFgGBPtQOUcuFiqFIYspUrjl4wfe/2TfN5gpc5bsm13znF/ya35rDru+ISBqwbeAHVGCkMQcmoJpSVQsODERIroxpA5jEkgUHAZRsRpxcCYIojUSdTF6hLCKcYecfEzADkRQcXHu5uPwOZ6e9sdpmD7G43zO7/P3V7sfLtd5OI3T5Zz/c2d7cD9C0cIktBirLzMY54oJOmA29vFOmRYGJaeghKFmGAtTZVjNoAvD3/E8gBHx31Uf1cwnik7QLKwMb4zJaQgQybb2kMA7khBZqGZIhfnyVmHTrHwZVMcFiuEjmx1+AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Data de Modificação" = _t, OwnerTeam = _t]),
    Removed = Table.ReplaceValue(Source,
            each List.Count(Text.Split([OwnerTeam], ";")),
            null,
            (x,y,z) => if List.Count(Text.Split(x, ";")) > y then Text.AfterDelimiter(x, ";") else x,
            {"Data de Modificação"})
    in
        Removed