Re:Lambdas as values in Excel
by snthpy on Tuesday August 24, 2021 @01:51AM
(#28285526)
I really like the M Language and Power Query (PQ) makes it really easy and convenient to build data mashups. You can even use it as a SQL query builder by viewing the Native Query code and then copying that.
The main issue I'm facing is how to distribute the library of PQ/M functions I've developed?
Currently I have a central library workbook and then have to copy code from there. Problem is that updates and bugfixes don't flow downstream.
I really hope Microsoft creates a solution for this. Would love to hear about some approaches for handling this in the meantime.
Re:Lambdas as values in Excel
by cosmie on Tuesday August 24, 2021 @04:22PM
(#28294471)
There are a few third party libraries/projects that are useful for that situation. Libpq[1] is one, and this[2] project is another. The readme for that second one includes links to several other M/PQ related projects.
The main issue I'm facing is how to distribute the library of PQ/M functions I've developed?
Currently I have a central library workbook and then have to copy code from there. Problem is that updates and bugfixes don't flow downstream.
I really hope Microsoft creates a solution for this. Would love to hear about some approaches for handling this in the meantime.