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.
In power Query I was trying to sort by using two columns and I keep getting this error.
Expression.SyntaxError: Toekn Comma expected.
= let
Source = Excel.Workbook(File.Contents("M:\Quarterly KPI\KPI Data.xlsx"), null, true),
ALLDATA_Sheet = Source{[Item="ALLDATA",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(ALLDATA_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"QRT", type text}, {"MONTH", type text}, {"CAT", type text}, {"TYPE", type text}, {"VALUE", Int64.Type}}),
#"Sorted Rows" = Table.Sort({{"MONTH", Order.Ascending}},{"CatSort",Order.Ascending}})
in
#"Changed Type"
Solved! Go to Solution.
Hi PPalkowski,
Whehn you want to sort, you could refer to refer to below M code(which refer to previous step's result and sort acs)
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUTICYQNDS31DfUOlWJ1opSSggDFM0AhJ0AxdJUi7OYrKWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [name = _t, amount = _t, date = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"name", type text}, {"amount", Int64.Type}, {"date", type date}}),
#"Sorted Rows" = Table.Sort(#"Changed Type",{{"date", Order.Ascending}, {"amount", Order.Ascending}})
in
#"Sorted Rows"
You need remove } from MONTH, and add a reference in sort function.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi PPalkowski,
Whehn you want to sort, you could refer to refer to below M code(which refer to previous step's result and sort acs)
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUTICYQNDS31DfUOlWJ1opSSggDFM0AhJ0AxdJUi7OYrKWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [name = _t, amount = _t, date = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"name", type text}, {"amount", Int64.Type}, {"date", type date}}),
#"Sorted Rows" = Table.Sort(#"Changed Type",{{"date", Order.Ascending}, {"amount", Order.Ascending}})
in
#"Sorted Rows"
You need remove } from MONTH, and add a reference in sort function.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.