Forum Discussion
Angith_Nair
Continued Contributor
Continued ContributorAdd Column using column from examples.
Hello team, I just want to convert values in the form which is shown below... Here "Column" is a raw column and I want to convert the values like "Custom" column. Basically what I want is If ...
Angith_Nair
Add the following as a Custom Column:=if Value.Is(Value.FromText([ABC Custom]), type number) then [ABC Custom] else Text.Start([ABC Custom],3)
Fowmy
Super User
Super UserAngith_Nair
Add the following as a Custom Column:
=if Value.Is(Value.FromText([ABC Custom]), type number) then [ABC Custom] else Text.Start([ABC Custom],3)
Angith_NairContinued Contributor
Continued ContributorHi Fowmy ,
That worked....thank you so much...I really appreciate it...