Forum Discussion

Miss_A's avatar
Miss_A
Regular Visitor
2 years ago
Solved

if text.length

= Table.AddColumn(#"Renamed Columns", "Custom", each if Text.Length[MonthYear]=6 then "0"&[MonthYear] else [MonthYear])

 

When I write the formula for 1-2023 to 01-2023

 

Expression.Error: We cannot apply field access to the type Function.
Details:
Value=[Function]
Key=MonthYear

Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    Miss_A 

    This method should work for you.

    Date.ToText(Date.FromText( "1-" &  [Column1],"en-gb"), "MM-yyyy")

     

     

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    Miss_A 

    This method should work for you.

    Date.ToText(Date.FromText( "1-" &  [Column1],"en-gb"), "MM-yyyy")

     

     

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    You forgot some parentheses

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQ1MjAyVorVATJh7FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [MonthYear = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each if Text.Length([MonthYear])=6 then "0"&[MonthYear] else [MonthYear])
in
    #"Added Custom"