Forum Discussion
Solved
Custom function Expression Error: 1 argument passsed which expects 2 arguments.
I've been staring at this code for 2 days. Receiving the following error: Error: Expression.Error: 1 arguments were passed to a function which expects 2. Arguments = <ccon>{Binary.FromText(...)}</c...
the error seems to be with Binary.FromText. But that is nowhere in your querey, so there must be more.... I totally agree with Anonymous though, nobody is going to read through all that M code.
Word of advide: Do yourself a favor and clean up your query first:
- remove all columns you don't need in the first step
- do change type as soon as you can
- split you query in logical blocks. For eaxmple start a new query after a group by referring to the result of the group by.
PwerQueryKees
Super User
Super Userthe error seems to be with Binary.FromText. But that is nowhere in your querey, so there must be more.... I totally agree with Anonymous though, nobody is going to read through all that M code.
Word of advide: Do yourself a favor and clean up your query first:
- remove all columns you don't need in the first step
- do change type as soon as you can
- split you query in logical blocks. For eaxmple start a new query after a group by referring to the result of the group by.
Thank You! I'll work on your recommendations!
