Latest

  • Inspecting Function “subtypes” in Power Query
    PowerQuery has metadata that you don’t normally see. For example, take the function Table.FromRecords Create a new blank query, and set the value to a function’s name. When you reference a function without arguments or parenthesis, it displays documentation. ( It’s mostly the same as the online docs ) Where does this come from? A […]
  • Experiments of 2022-09
    Power BI / Power Query Things to note options is an record, when used this way it’s similar to Python’s kwargs Merging two records with update the existing fields, adding new fields, if they do not yet exist (in PowerQuery) the order of steps don’t change the final result (order of execution is the same) […]
  • Experiments of 2022-08
    Query to Summarize All Queries Summarize.Query.pq Using Inline Images and SVG in a Power BI Table With the column set to Image Url, you’re able to use an external image like https://www.fakeurl.com/image.png or output a svg image programmatically, by placing logic in a measure or embedded a raw a .png image into the model/report itself […]
  • Animations of 2022-07
    Single File With Automatic Inline Testing Addon: https://marketplace.visualstudio.com/items?itemName=pspester.pester-test Plus Error Lens
  • Viewing Default Settings in VS Code
    Where is the default settings.json or keybindings.json ? There isn’t one, because it’s dynamically generated. When you run run the ‘default settings’ command, it builds a new one — this means it’s always up to date. It includes settings from all enabled addons. Command Palette: The Only Hotkey You Need to Remember. Can’t remember what […]
  • Experiments of 2022-04
    FdFind, Ansi Colors with Group-Object Using wt‘s Parameters Nested Formatting in Powershell CLI bat to preview results Regex Lazy vs Greedy Expressions Using CSS Selectors Autocomplete changes based on the first Argument Parsing Stdout Whitespace Using Format-ControlChar Grouping On Errors Type Resolution Is Scoped
  • How Do I Get Started with Power Apps? With Cheat Sheets
    The Documentation Is Great Check out the examples for Filter , you can experiment without configuring a data source Top Level, New To Apps entry point: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/ Sample Data Without a Data Source – Declaring Inline Tables Step1: Choose Insert -> Button. Step2: Set the button’s OnSelect property to this. Step3: Alt left click the […]
  • Experiments / Answers of 2022-02
    File Selection CLI Revisiting BASH See more Detect Valid Values for gh –json — then Fzf filter them PowerApps: Visualize filter in Queries Is there a way to add columns Programically to many queries? Labeled Summary of all queries VS Code Syntax Highlighting when $null + 3 + 3 = 12 Random Power Query Power […]
  • Experiments of 2021-10
    Experiments: DAX, Pwsh, VS Code
  • Run DAX in Your Browser: SQL-BI.com has a DAX Web App | What’s New
    Dax Web App ( From sqlbi.com )
  • Word Wrapping Text in Power Query
    Word wrapping text using List.Accumulate and Occurrence.LastPower BI
  • Power Query Custom Functions – Cheat Sheet
    Declaring optional parameters in custom functions, combine multiple Web.Contents queries, without refresh errors. Using Html.Table with custom CSS Selectors
  • Big List of Cheat sheets and References
    Web Technologies, Specs, Programming, and Configuration
  • Creating a Discord Webhook in a few lines of PowerShell
    Discord Web Hooks are easier than you’d think. It uses a regular `HTTP` web request . Step1: Creating your webhook url Go to: Server Settings -> Integrations -> View WebhooksThen click create webhook. Step2: Invoke-RestMethod Success! Docs There are optional webhook arguments to customize the output: https://discord.com/developers/docs/resources/webhook#execute-webhook Comparison with curl I tried making curl easier […]
  • Improving ‘diff’ readability on Windows | Tip
    The output of diff -q path1 path2 is pretty verbose. This function Converts full paths to relative Differences are red. Missing ‘diff’ ? If git is installed, you may need to update your %PATH% environment variable. Stand-Alone function Compare-Directory This is an isolated version of <a href="https://github.com/ninmonkey/Ninmonkey.Console">Ninmonkey.Console: Compare-Directory</a> . I removed all dependencies except coloring […]
  • Easy way to cache results on the Command Line | Power Shell Tip
    Sometimes you’ll need to run a command with the same input with different logic. This can be a hassle using a slow command like Get-ADUser or Get-ChildItem on a lot of files like ~ (Home) with -Depth / -Recurse PowerShell 7.0+ Powershell 7 added the Ternary Operator, and several operators for handling $null values. All […]
  • Web.Contents: Using Dynamic and Duplicate key names in a Query
    Power BI Discord asked the question:> How do you use duplicate keys, and dynamic urls with <a href="https://docs.microsoft.com/en-us/powerquery-m/web-contents">Web.Contents</a> ? (They were using a web API that required duplicate keys) After I wrote this, Chris Webb found an easier solution. Requirements You can’t use a regular record because keys must be distinct. Query = [ Key1 […]
  • Preserving Types When using “Add Custom Column” in Power Query
    Why doesn’t the original [Num] * 2 work? Powerquery does not know what type will be returned by your function. That’s because each is by definition a function that returns type any See More see the each expression in the Lexical Grammar Docs on Power Query each functions
  • PowerShell : Prefixing lines with the Pipe operator |
    It’s cleaner to read, and makes it easier to insert, delete, or toggle comments on the console.
  • Reusable Calculated Properties in PowerShell
    The function Label is from the module: github.com/Ninmonkey.Console