Ninmonkey.PowerQueryLib
Custom functions for Power BI (by ninmonkey)
ninMonkQuery-examples
Power Query Examples, with a bit of monkey business. (by ninmonkey)
Ninmonkey.PowerQueryLib | ninMonkQuery-examples | |
---|---|---|
17 | 21 | |
19 | 8 | |
- | - | |
6.2 | 9.1 | |
6 days ago | 11 days ago | |
PowerShell | PowerShell | |
MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Ninmonkey.PowerQueryLib
Posts with mentions or reviews of Ninmonkey.PowerQueryLib.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-22.
-
VBA Code to Dump PowerQuery Queries to Text File
I'm guessing you're using reference or a lot of functions? I wrote a script that reads a bunch of files that are 1 function per file. Then it merges it as one big record-expression like this PowerQueryLib.pq
-
Joining API requests via custom columns
Here's an example testing SSL Errors in Powerquery.pq . I Need to update that, it was written before try catch existed.
- Web.Contents based on information in columns (each row) iteration
-
How to import, and update queries from outside of Excel
github.com/Ninmonkey.PowerQueryLib/ninlib.pq -- note, that's an older version I've been meaning to update -- but I thought you'd be interested
-
How do you prefer to create your Date table? (DAX, Power Query, static file, etc)
List.ContinuousDates.pq I'm not sure on the name, I needed something to show it's going to generate a valid datetable
-
generating a date series for each row
github/ninmonkey/List.ContinuousDates.pq
-
What did you make this month? -- Or what's mysterious in PowerQuery that you'd like to know?
ninlib.pq
-
Connecting to social media APIs
WebRequest_Simple.pq
-
What’s a good method of creating an archive of a table from a webpage, so that it can be read by Power Query / PBI?
If you take this function: https://github.com/ninmonkey/Ninmonkey.PowerQueryLib/blob/master/source/WebRequest_Simple.pq
-
What quality of life reusable Macros / vba should I setup to make my life easier in Excel?
using For(x=0; x<5; x++) loops in Power Query
ninMonkQuery-examples
Posts with mentions or reviews of ninMonkQuery-examples.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-20.
-
Can powerbi connect to anything with an API?
If you search my github or reddit (or the powerbi discord) history, I have a bunch of random questions I answered. - here's a partial list: https://github.com/ninmonkey/ninMonkQuery-examples/blob/main/forumQuestions/readme.md
- Power Query: Split multiple columns, then merge as multiple columns with calculated key names
-
Output string showing differences between other strings?
let Letters = {"a".."z"}, Str = [ Null = "␀" ], SeeMoreAt = "https://github.com/ninmonkey/ninMonkQuery-examples", // Jake Bolton, 2023-05 // quick function to csv-ify a list, if possible. // did you know let expressions are actually // sugar for record expressions? for example ToCsv = (source as list) as text => [ items = List.Transform( source, (item) => try Text.From(item) catch (e) => Str[Null] ), join = "{ " & Text.Combine(items, ", " ) & " }" ][join], // another way to preview, if the default conversion is good enough ToJson = (source as any) as any => let bytes = Json.FromValue(source), lines = Text.FromBinary( bytes, TextEncoding.Utf8 ) in lines, numChars = List.Count(Letters), tests = { [ Start = 0, Count = null ], [ Start = 0, Count = 3 ], [ Start = 3, Count = 4 ], [ Start = 8, Count = null ], [ Start = 8, Count = 9999 ], [ Start = numChars -3, Count = null ] }, test_table = tests, Summary = [ Letters = Letters, tests = tests ], tests1 = Summary[tests], #"Converted to Table" = Table.FromList(tests1, Splitter.SplitByNothing(), null, null, ExtraValues.Error) in #"Converted to Table"
-
When querying Excel files that with mutlilevel grouping, is it possible to preserve, or at least somehow make note of row level/outline structure?
screenshot: filtering-nested-values-without-expanding-json.png and example usage.pq
-
VS Code - Advanced Editor - .pq files - Best practice recommendations?
https://github.com/inMonkQuery-examples/Power-Query-For-Programmers
-
Replace values in one column based on 3 criteria
screenshot of results from github.com/ninmonkey/monkQuery
-
Data Format Error
Or use Text.Inspect("string")
-
Conditional result tied to a list of values
or get the full report from ninmonkey/ninMonkQuery/mapping table readme.md
-
Return text value with SWITCH function
It's from the the animals pbix here https://github.com/ninmonkey/ninMonkQuery-examples/tree/main/Unicode
- Turning Four Columns into Two
What are some alternatives?
When comparing Ninmonkey.PowerQueryLib and ninMonkQuery-examples you can also consider the following projects:
Bravo - Bravo for Power BI