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
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
