Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JimB-GA
Helper III
Helper III

How to parse a field in DAX

Hello.  Still a newbie and trying to parse a field into new columns.

Following is the sample table:

 

DateDescription

08/01/18Bought 1.206 Spy @ 281.0819
05/01/18Bought 1.131 Spy @ 262.8647
02/06/18Bought 40 Spy @ 264.8895
02/02/18Bought 36 Spy @ 278
02/01/18Bought 0.576 Spy @ 282.3045
12/18/17Bought 74 Spy @ 268.4641
11/15/17Bought 40 Rpg @ 102.96
11/01/17Bought 48 Rpg @ 103
11/01/17Bought 0.383 Spy @ 257.568
10/03/17Bought 0.261 Vcr @ 143.92

 

I would light to parse the description field into the security purchased, quantity, and price.  I can do this in Excel, but DAX eludes me.  Can someone help?  Very much appreciated.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hey @JimB-GA

 

You can do this very easily using the Column from examples functionality in the Query Editor, no DAX required. Simply click Edit Queries, select your table, navigate to the Add Column tab, and on the top left you will see Column From Examples. Then start typing the value you would expect in that column for that row.

 

If you want a walkthrough on how to do it, check out this video:

 

https://www.youtube.com/watch?v=kJ37glO4wBY

 

Hope this helps,

Parker

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hey @JimB-GA

 

You can do this very easily using the Column from examples functionality in the Query Editor, no DAX required. Simply click Edit Queries, select your table, navigate to the Add Column tab, and on the top left you will see Column From Examples. Then start typing the value you would expect in that column for that row.

 

If you want a walkthrough on how to do it, check out this video:

 

https://www.youtube.com/watch?v=kJ37glO4wBY

 

Hope this helps,

Parker

 

 

Works perfectly. Thanks Parker!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors