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 can...
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")

     

     

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"