Forum Discussion
How to use each expression in M Language
Hello Community, I am learning M language (let-in structure), and I have a question relevant to 'each' expression The online course/video I am taking, is teaching how to use each. I try to ...
Hi Anonymous,
the problem is that the second parameter of Table.Group should be text instead of column identifier.
Custom1 = Table.Group(#"ChangedType", "Tasks", {"ML Test", each _})instead of
Custom1 = Table.Group(#"ChangedType", [Tasks], {"ML Test", each _})You can also read more about that in the PowerQuery Documentation: Table.Group
Hi Anonymous,
the problem is that the second parameter of Table.Group should be text instead of column identifier.
Custom1 = Table.Group(#"ChangedType", "Tasks", {"ML Test", each _})instead of
Custom1 = Table.Group(#"ChangedType", [Tasks], {"ML Test", each _})You can also read more about that in the PowerQuery Documentation: Table.Group
Tks sooo much Nolock. It works now.
At first I thought it's the each key expression went wrong.
Thank you very much.