Miss_ARegular Visitor2 years agoSolvedif 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...Show MoreFowmy2 years agoMiss_A This method should work for you. Date.ToText(Date.FromText( "1-" & [Column1],"en-gb"), "MM-yyyy")
Fowmy2 years agoMiss_A This method should work for you. Date.ToText(Date.FromText( "1-" & [Column1],"en-gb"), "MM-yyyy")
Fowmy2 years agoMiss_A This method should work for you. Date.ToText(Date.FromText( "1-" & [Column1],"en-gb"), "MM-yyyy")
FowmySuper User2 years agoMiss_A This method should work for you. Date.ToText(Date.FromText( "1-" & [Column1],"en-gb"), "MM-yyyy")
Related contentIF Statement with Text.Length and ConcatUsing Text.Length in an IF StatementText.Length Concat helpCorrect Syntax for Table.TransformColumns + Text.Length + Text.CombineUse Text.Length to extract certain length of the text string
