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.
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 Column has values that are in pattern "T6H5N6" then I want the first 3 characters which will be "T6H" and if the values are purely numeric i.e "235875" then I want that value as it is. Please note that the length of the characters/numbers is 6 which is constant. How can I acheive this in Power Query?
Thanks in advance.
Solved! Go to Solution.
@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)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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.