Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.8647 |
02/06/18 | Bought 40 Spy @ 264.8895 |
02/02/18 | Bought 36 Spy @ 278 |
02/01/18 | Bought 0.576 Spy @ 282.3045 |
12/18/17 | Bought 74 Spy @ 268.4641 |
11/15/17 | Bought 40 Rpg @ 102.96 |
11/01/17 | Bought 48 Rpg @ 103 |
11/01/17 | Bought 0.383 Spy @ 257.568 |
10/03/17 | Bought 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.
Solved! Go to Solution.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
50 | |
38 | |
38 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |