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.
hello,
I'm new to coding in Power Query.
I tried adding the last line #"Padded Values" to the existing code but I am getting the Token Comma expected error.
Can someone please explain why?
Thank you
let
Source = Excel.Workbook(File.Contents(XLS), null, true),
Areas_Sheet = Source{[Item="Areas",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Areas_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"AreaScheme", type text}, {"Level", type text}, {"Number", type text}, {"Name", type text}, {"Area", type number}, {"CTA.ZoneCode", type text}}),
#"Inserted Last Characters" = Table.AddColumn(#"Changed Type", "Last Characters", each Text.End([Level], 2), type text),
#"Renamed Columns" = Table.RenameColumns(#"Inserted Last Characters",{{"Last Characters", "LevelPrefix"}})
#"Padded Values" = Text.PadStart(#"Padded Values",[Level Prefix],5,"0")
in
#"Padded Values"
Solved! Go to Solution.
All steps except the last need a comma after them. Add a comma at the end of your #"Renamed Columns" step.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
HI I am new to coding in Power Query. I am
I am getting the Token Comma expected error.
Can someone please explain why?
Thank you
let bernDistAna = (hitNum) => {
let p = sum(hitNum)/count(hitNum);
return hitNum * (1 - p);
};
Your last step is referencing itself (so that variable doesn't exist yet). Change it to reference your previous step.
#"Padded Values" = Text.PadStart(#"Renamed Columns",[Level Prefix],5,"0")
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you @mahoneypat
But now I am getting the following error.
Expression.Error: The name 'Padded Values' wasn't recognized. Make sure it's spelled correctly.
All steps except the last need a comma after them. Add a comma at the end of your #"Renamed Columns" step.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |