Power Query custom function variable to make table a list

Well sought of in that I'ts fine as far as syntax errors go but it doesn't work?

I have this wherer I've created the Units variable, but left it hardcoded ;

Please Login or Register  to view this content.

Which works, but as soon as I try to introduced the 'mylist' to replace [Units] I get an error. I don't think it likes the comma, and table.column
is the only way I can think of around it but that don't work either.

This is strange;
I pasted yours into notepad with mine below and went through it, having just tried mine and got an error ;

Rory;

Please Login or Register  to view this content.

So I deleted mine and pasted yours into the the editor tried it and it worked, so started again and made new function from scratch,
and still get the same error, 'cannot convert table to list', any ideas, I'll replace workbook with one showing both your working and mine.

Richard.

Just to add add named your rory an my not working mine.

to Ali, sorry missed an 's I named rory's verson after him to distinguish form what I had done.

Thank you,
Right I'm going to have to experiment with that, I really thought I'd compared them both, now I've looked at it I almost see why it's needed, almost,
RD

Sorry can't spell, meant yours as in I'd named Rory's after him.