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!
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
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
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
