March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi everyone!
Is it possible to Create Column and perform Transformation in Single Step.
Below are the two steps I use at the moment, however was wondering if there was a more efficent way to do this in a single step.
#"Step 2" = Table.DuplicateColumn(#"Step 1", "Plan Item", "Plan"),
#"Step 3" = Table.TransformColumns(#"Step 2", {{"Plan", each Text.Start(_, 3), type text}}),
Any help or advice would be most appreciated!
Thanks!
Solved! Go to Solution.
= Table.AddColumn(#"Step 1", "Plan", each Text.Start([Plan Item], 3))
You can add a column instead
= Table.AddColumn(#"Step 1", "Plan", each Text.Start([Plan Item],3), type text)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
= Table.AddColumn(#"Step 1", "Plan", each Text.Start([Plan Item], 3))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
55 | |
27 | |
17 | |
12 |