User Profile
bpierceaxo
New Member
Joined 1 year ago
User Widgets
Contributions
Custom Column
I am trying to create a Custom Column with data from another column. I have a column that has 4 digits for the Dept # and I only want to use the first three. When I use the Left function - = Table.AddColumn(#"Sorted Rows", "Dept", each LEFT([code], 3)) code is the orginal column name I get the following error message. Expression.Error: The name 'LEFT' wasn't recognized. Make sure it's spelled correctly.Solved2KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.