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 Ninmonkey.Console: Compare-Directory . I removed all dependencies except coloring is […]
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 Web.Contents ? (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