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
Is there a way I can split a column on an upper case? I got a dataset with multiple values but no delimittor?
Here's the problem; I want to seperate first and last names.
Solved! Go to Solution.
Hi @jochendecraene ,
In PQ, select your [Name] column, then go to Transform tab > Split Column (dropdown) > 'By Lower Case to Upper Case'.
You can change new column names by editing values in the formula bar here:
Pete
Proud to be a Datanaut!
Hi @jochendecraene ,
In PQ, select your [Name] column, then go to Transform tab > Split Column (dropdown) > 'By Lower Case to Upper Case'.
You can change new column names by editing values in the formula bar here:
Pete
Proud to be a Datanaut!
Thank you so much for the quick response!
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.