Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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))
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
User | Count |
---|---|
16 | |
14 | |
8 | |
8 | |
7 |