Forum Discussion
Remove first 2 characters from a column value
From PQE, you can perform the below for having last 2 digits of Number column:
1. Duplicate the Number column2. Perform below operations from Home ->Transform section at top:
Split Column >> By Number of Characters
3. Modify with below:
Number of Characters = 2
Split = Once, as far right as possible
4. Remove unwanted split column and rename new column
Alternatively, you can use below formula in Advanced Editor:
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "Number", "Duplicated Number"),
#"Split Column by Position" = Table.SplitColumn(Table.TransformColumnTypes(#"Duplicated Column", {{"Duplicated Number", type text}}, "en-IN"), "Duplicated Number", Splitter.SplitTextByPositions({0, 2}, true), {"Duplicated Number", "New Number"}),
#"Removed Columns" = Table.RemoveColumns(#"Split Column by Position",{"Duplicated Number"})Don't forget to give thumbs up and accept this as a solution if it helped you !!!
No MID is also not recognised.
Are RIGHT and MID DAX functions?
As stated I'm in PQE.
In PQE(Power Query Editor), follow below steps:
1. Right click 'Old' columnname
2. Click on 'Split Column'
3. Click on 'By Positions...' (3rd option)
4. Type 2 in positions text field
5. Click OK
6. Rename the column to "New"
If you want to keep both 'Old' as well as 'New' columns, make sure you duplicate the column first and then perform above steps on duplicated column.
Don't forget to give thumbs up and accept this as a solution if it helped you !!!