Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.