ninMonkQuery-examples Alternatives

ninMonkQuery-examples reviews and mentions

• Can powerbi connect to anything with an API?
  1 project | /r/PowerBI | 7 Dec 2023

  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
  1 project | /r/iamverynin | 17 Nov 2023
• Output string showing differences between other strings?
  1 project | /r/PowerQuery | 9 May 2023

  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?
  1 project | /r/PowerQuery | 20 Apr 2023

  screenshot: filtering-nested-values-without-expanding-json.png and example usage.pq

• VS Code - Advanced Editor - .pq files - Best practice recommendations?
  2 projects | /r/PowerQuery | 20 Mar 2023

  https://github.com/inMonkQuery-examples/Power-Query-For-Programmers

• Replace values in one column based on 3 criteria
  1 project | /r/PowerQuery | 10 Feb 2023

  screenshot of results from github.com/ninmonkey/monkQuery

• Data Format Error
  1 project | /r/PowerBI | 22 Jan 2023

  Or use Text.Inspect("string")

• Conditional result tied to a list of values
  1 project | /r/PowerQuery | 13 Jan 2023

  or get the full report from ninmonkey/ninMonkQuery/mapping table readme.md

• Return text value with SWITCH function
  1 project | /r/PowerBI | 10 Jan 2023

  It's from the the animals pbix here https://github.com/ninmonkey/ninMonkQuery-examples/tree/main/Unicode

• Turning Four Columns into Two
  1 project | /r/PowerQuery | 31 Dec 2022
• A note from our sponsor - SaaSHub
  www.saashub.com | 4 May 2024

  SaaSHub helps you find the best software and product alternatives Learn more →