Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'm currently working with a dataset that uses one POL field/column for updates. The newest update will be added first with the update date then the update itself. There's usually a new line character added after every update but Power BI doesn't recognise this when importing the data.
Is there a way to split this column before the 2nd date to only keep the first update? The field data would look something like this:
24/12/23 Update 1 1/1/24 Update 2 12/2/24
I've tried looking at using wildcards but this doesn't look like Power BI utilises them.
Solved! Go to Solution.
Hi, @Chantine
You can try the following methods.
Split Column-Enter a space-Left-most delimiter:
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Chantine
You can try the following methods.
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi z-zhangti,
Thank you for replying.
Unfortunately not quite! The desired output from my example data would be to have '24/12/23 Update 1' seperated out.
Hi, @Chantine
You can try the following methods.
Split Column-Enter a space-Left-most delimiter:
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |