The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm having a slight issue with converting numbers into text and back. Half of my Microsoft Forms is both text and numbers
Here are some examples
Some records contain numbers and strings (411- Prototyping & Tooling). Check the source and correct them
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi and thank you very much. This wasn't the solution I was looking for as the data is coming from a live Microsoft Form that I don't necessarily own myself
You do some cleaning in Power Query then, like Split after delimiter "-". you should then have a column with numbers Format.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook