Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a column of data I'm trying to split out that looks like the folowing:
Academic Pay FN40 Academic Support J000613 - Librarian - III Monthly P0064472 Librarian - III - NAME HERE Regular UNLV1-Medical District |
All of my attempts to break this out into multiple columns has failed. Looking for suggestions. I'm relatively new to Power BI, so apologies if I've overlooked something simple.
Solved! Go to Solution.
Hi @SmedinghoffUNLV ,
Would you please try to split the column by line break(#(lf))?
Then move the blank columns:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @SmedinghoffUNLV ,
Would you please try to split the column by line break(#(lf))?
Then move the blank columns:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |