Declaring optional parameters in custom functions, combine multipleWeb.Contents queries, without refresh errors. Using Html.Table with custom CSS Selectors
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 […]
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 […]
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 […]
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 […]
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
The final number of missing identifiers* Generating the list using #shared To get a list of all identifiers (functions, variables, constants) I use the variable named #shared . Create a new blank query, then paste this I copy using Copy Entire List, then storing the results into a PowerShell variable. I Repeat the same with […]
Getting started with PowerShell Main Language Keywords and Grammar including control flow about Operators Flow Control about_ScriptBlocks (anonymous functions) Grammar switch statements functions Important Topics, Language quirks For( ;; ) vs ForEach vs ForEach-Object about_ForEach ( control loop) about_For ( control loop) ForEach-Object ( Note: this is a command, not a control loop ) It’s […]
The Model view allows you to set a global default “Summarize By” type for every column.You still have the ability to override the aggregation type per-visual in Report view
Experiments: DAX, Pwsh, VS Code
Dax Web App ( From sqlbi.com )
Word wrapping text using
Declaring
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 […]
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 […]
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 […]
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
It’s cleaner to read, and makes it easier to insert, delete, or toggle comments on the console.
The function Label is from the module: github.com/Ninmonkey.Console
The final number of missing identifiers* Generating the list using #shared To get a list of all identifiers (functions, variables, constants) I use the variable named #shared . Create a new blank query, then paste this I copy using Copy Entire List, then storing the results into a PowerShell variable. I Repeat the same with […]
Searching for Parameters using case-insensitive regular expressions
High quality Tutorials, tools, and blog posts for Power Query