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.
Thanks to Bill Szysz at Excelguru for helping me with getting started with this porject.
After added the Grouped Rows line of code with my column name, I am getting a "Token Comma expeted" error when show error
"tbl" is high lighted. I verified all column names a correct, not sure what else to look for.
Thank you in advance for any and all suggestions.
OldCityCat
let Source = Table.NestedJoin(RowOne,{"Employee_Num"},RowTwo,{"Employee_Num"},"RowTwo",JoinKind.LeftOuter), #"Expanded RowTwo" = Table.ExpandTableColumn(Source, "RowTwo", {"Name", "Employee_Num", "Code", "Date", "DailyAmount"}, {"RowTwo.Name", "RowTwo.Employee_Num", "RowTwo.Code", "RowTwo.Date", "RowTwo.DailyAmount"}), #"Removed Other Columns" = Table.SelectColumns(#"Expanded RowTwo",{"Name", "Employee_Num", "Code", "Date", "Hours", "RowTwo.DailyAmount"}), #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns", {"Employee_Num", "Date"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"RowTwo.DailyAmount", "DailyAmount"}}), #"Grouped Rows"= Table.Group(#"Renamed Columns", {"Employee_Num}, {{"tbl", each _ & Table.FromRecords({[#"Employee_Num"=null]}), type table [Name=text, Employee_Num=number, Code=text, Date=date, Hours=number, DailyAmount=number]}},0) in #"Renamed Columns"
Solved! Go to Solution.
Your missing a " at the end of"
"Employee_Num
Thanks for your reply, I guess I didn't see the forest for the trees.
After fixing the " and refreshing the query, I expected to see a new table with two columns
Employee_Num and tbl with a expand option. No such luck.
I still must be missing something.
Any Ideas?
Seems to work fine for me.
Are you getting an error, or what are you seeing?
I found my problem,
I needed to change In to "#Rename Columns"
Work as expected
#"Grouped Rows"= Table.Group(#"Renamed Columns", {"Employee_Num"}, {{"tbl", each _ & Table.FromRecords({[#"Employee_Num"=null]}), type table [Name=text, Employee_Num=number, Code=text, Date=date, Hours=number, DailyAmount=number]}},0) in #"Renamed Columns"
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.