Forum Discussion
Solved
Addcolumn + format + &&
Hi - newby here. I want to add a column in a table from 2 fields: Account and sub account. The account is 123 Sub account is 45 My standard GL format is "000000-0000" I'm looking for th...
= Table.AddColumn(Source, "Custom", each Text.PadStart([Column1], 6, "0") & "-" & Text.PadStart([Column2], 4,"0"))
Make sure that the two fields are text before this line. I think there's a slight mismatch between your format ( is "000000-0000") and the result you gave (00123-0045)
= Table.AddColumn(Source, "Custom", each Text.PadStart([Column1], 6, "0") & "-" & Text.PadStart([Column2], 4,"0"))
Make sure that the two fields are text before this line. I think there's a slight mismatch between your format ( is "000000-0000") and the result you gave (00123-0045)
Wow thanks so much!
