Forum Discussion
Power Query working standalone, but not in function
Well, it turns out that one has to be careful with column format definition. If you have column in general format, it adds up ok in stand-alone query, but fails if the query is organized as a function. When I define column as Decimal or Integer it all works as expected both in stand-alone query and function.
Well, it turns out that one has to be careful with column format definition. If you have column in general format, it adds up ok in stand-alone query, but fails if the query is organized as a function. When I define column as Decimal or Integer it all works as expected both in stand-alone query and function.
Hi gvg,
It seems that you have solved your problem, please accept the your replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
