You can view the final .pq query here 3 Main Methods to Declare Optional Parameters There’s 3 main ways you can declare optional parameters in your own functions. By setting your parameter type to nullable type. name as text becomesname as nullable text This version requires you to always pass something, even if it’s null. […]
White Space before a function call is allowed Whitespace between function calls and the name are allowed. Including newlinesThese are equivalent statements: Record lookups also allow whitespace. This is totally valid syntax wise. Not necessarily morally though. Misleading Comments inside Lists, Records, and Function Calls are allowed Comments do not affect parsing or execution.Without syntax […]
Have you written a report where dates import right. But they break when ran on another machine? If you import right, you don’t have to set cultures in your report settings.
Summary Any value in Power Query can store info in a metadata record. “Datasources” often have extra info. Web.Contents exposes the full request url including the Query variables, request headers, HTTP Status codes, and more. You can view the final query here: Part 1 – Capturing Response Metadata.pq or as a pbix Finding the binary […]
Dax Keeps pouring out new Functions. DAX So Many New DAX functions New: MatchBy, Rank, RowNumber, LINEST, LINESTX , Index, Offset, OrderBy, PartitionBy, Window, EvaluateAndLog, ToCsv, ToJson, NetWorkDays [ from 2022-07 to 2023-06 ] new RANK and ROWNUMBER [2023-04] ORDERBY was updated [2023-04] new: INDEX, OFFSET, WINDOW [2022-12] there’s a long introduction that covers how […]
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 […]
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) […]
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 […]
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 […]
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
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 […]
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 […]
Declaring optional parameters in custom functions, combine multipleWeb.Contents queries, without refresh errors. Using Html.Table with custom CSS Selectors
You can view the final .pq query here 3 Main Methods to Declare Optional Parameters There’s 3 main ways you can declare optional parameters in your own functions. By setting your parameter type to nullable type. name as text becomesname as nullable text This version requires you to always pass something, even if it’s null. […]
White Space before a function call is allowed Whitespace between function calls and the name are allowed. Including newlinesThese are equivalent statements: Record lookups also allow whitespace. This is totally valid syntax wise. Not necessarily morally though. Misleading Comments inside Lists, Records, and Function Calls are allowed Comments do not affect parsing or execution.Without syntax […]
Have you written a report where dates import right. But they break when ran on another machine? If you import right, you don’t have to set cultures in your report settings.
Summary Any value in Power Query can store info in a metadata record. “Datasources” often have extra info. Web.Contents exposes the full request url including the Query variables, request headers, HTTP Status codes, and more. You can view the final query here: Part 1 – Capturing Response Metadata.pq or as a pbix Finding the binary […]
Power BI AI using PowerShellAI
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 […]
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 […]
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
Experiments: DAX, Pwsh, VS Code
Dax Web App ( From sqlbi.com )
Word wrapping text using
Declaring