Custom function Expression Error: 1 argument passsed which expects 2 arguments.

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.