Forum Discussion

JimB-GA's avatar
JimB-GA
Icon for Helper III rankHelper III
8 years ago
Solved

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/18 Bought 1.206 Spy @ 281.0819 05/01/18 Bought 1.131 Spy @ 262....
  • Anonymous's avatar
    Anonymous
    8 years ago

    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