Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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))