Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the correct formula. The way I think it (that obviously doesn't work) is:
#"KeyGL" = Table.AddColumn(DBIFGV_Table, "KeyGLBase", each FORMAT([DBGV_ACCOUNT],"000000") & FORMAT([DBGV_SUB_ACCOUNT],"0000"))
The result I'm looking for would be 00123-0045
Thanks!
Solved! Go to Solution.
= 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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |