Solved: Split column where each row has different data or ...

Anonymous · ‎03-09-2020

Hello All,

I need to split below records into 2 columns where one column should have "business card sample" and second column should have "Feb 5, 2020, 5:13:30 AM EST"

Below are sample data rows:

Searched for business card sampleFeb 5, 2020, 5:13:30 AM EST

Viewed image from powerbicdn.azureedge.netJan 31, 2020, 10:58:53 AM EST

Searched for dark green hex codeJan 25, 2020, 3:54:39 AM EST

I tried column from examples but not working accurately for this since it has Different months data and it get confused between Feb, Jan, Mar etc.

Your help is appreciated. Thank you!

ImkeF · ‎03-09-2020

Hi @Anonymous

the only chance I see here is to split your text by "lowercase to uppercase":

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎03-09-2020

Hi @Anonymous

the only chance I see here is to split your text by "lowercase to uppercase":

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Split column where each row has different data or Extract data from between from text string

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly