Split column for specific value

[Anonymous]

Hello guys,

I would like to transform some values that markered in red from the column MESSAGE to a new columns TIMESTAMP and STATUS. Any suggestions to do that with PowerBI?

Kind regards!

[Rfranca · Accepted solution]

hi @Anonymous

This is easily resolved with EDITOR QUERY.

For this you must use resources to split columns.
1. Divide the time using the comma separator
2. Divide the status using the seprador to '

But beware of other data that follows the tab pattern for time and status.

(see the sequence of images)

Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

Best Regards,
Rfranca