{"id":1665,"date":"2021-02-20T21:11:53","date_gmt":"2021-02-21T03:11:53","guid":{"rendered":"http:\/\/ninmonkeys.com\/blog\/?page_id=1665"},"modified":"2021-02-20T21:31:57","modified_gmt":"2021-02-21T03:31:57","slug":"latest","status":"publish","type":"page","link":"https:\/\/ninmonkeys.com\/blog\/latest\/","title":{"rendered":"Latest"},"content":{"rendered":"<ul class=\"wp-block-latest-posts__list is-grid columns-5 has-dates alignwide wp-block-latest-posts\"><li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2024\/06\/05\/power-query-functions-part1-using-optional-parameters\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2024\/06\/part4-Blog-Post-Article-Image.2024-05-30-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2024\/06\/05\/power-query-functions-part1-using-optional-parameters\/\">Power Query Functions ( Part 1): Introduction to Optional Parameters<\/a><time datetime=\"2024-06-05T22:27:11-05:00\" class=\"wp-block-latest-posts__post-date\">2024-06-05<\/time><div class=\"wp-block-latest-posts__post-excerpt\">You can view the final .pq query here 3 Main Methods to Declare Optional Parameters There&#8217;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&#8217;s null. [&hellip;]<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2024\/06\/04\/what-not-to-do-in-power-query\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2024\/06\/What-Not-To-Do-Page-header-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2024\/06\/04\/what-not-to-do-in-power-query\/\">What Not To Do: When Letting Your Code Breathe Goes Bad<\/a><time datetime=\"2024-06-04T13:35:26-05:00\" class=\"wp-block-latest-posts__post-date\">2024-06-04<\/time><div class=\"wp-block-latest-posts__post-excerpt\">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 [&hellip;]<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2024\/06\/03\/how-to-import-dates-correctly-across-culture-or-locales\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2024\/06\/Pq-\u205e-Scene-2-Transform-Column-Types-With-Culture-\u205e-2024-05-\u205e-High-quality-low-color-\u205e-i0-Double-Duration-150x150.gif\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2024\/06\/03\/how-to-import-dates-correctly-across-culture-or-locales\/\">How to  Import Dates Correctly Across Culture  or Locales<\/a><time datetime=\"2024-06-03T18:24:02-05:00\" class=\"wp-block-latest-posts__post-date\">2024-06-03<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Have you written a report where dates import right. But they break when ran on another machine?  If you import right, you don&#8217;t have to set cultures in your report settings. <\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2024\/06\/01\/power-query-capturing-response-metadata-from-web-contents\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2024\/06\/Blog-Post-Header-Image.2024-05-31-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"Screenshot Viewing the metadata record in Power Query\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2024\/06\/01\/power-query-capturing-response-metadata-from-web-contents\/\">Capturing Metadata of your Web.Contents calls &#8211; Using REST APIs in Power Query<\/a><time datetime=\"2024-06-01T20:45:28-05:00\" class=\"wp-block-latest-posts__post-date\">2024-06-01<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Summary Any value in Power Query can store info in a metadata record. &#8220;Datasources&#8221; 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 &#8211; Capturing Response Metadata.pq or as a pbix Finding the binary [&hellip;]<\/div><\/li>\n<li><a href=\"https:\/\/ninmonkeys.com\/blog\/2023\/06\/09\/whats-new-may-2023\/\">What&#8217;s New: May 2023: Dax Functions, and PBI Fabric<\/a><time datetime=\"2023-06-09T17:25:13-05:00\" class=\"wp-block-latest-posts__post-date\">2023-06-09<\/time><div class=\"wp-block-latest-posts__post-excerpt\">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&#8217;s a long introduction that covers how [&hellip;]<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2023\/01\/22\/errors-of-2023-01\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2023\/01\/image-2-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2023\/01\/22\/errors-of-2023-01\/\">Errors of 2023-01<\/a><time datetime=\"2023-01-22T16:16:09-06:00\" class=\"wp-block-latest-posts__post-date\">2023-01-22<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Power BI AI using PowerShellAI<\/div><\/li>\n<li><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/10\/11\/animations-2022-10\/\">Animations 2022-10<\/a><time datetime=\"2022-10-11T19:55:31-05:00\" class=\"wp-block-latest-posts__post-date\">2022-10-11<\/time><div class=\"wp-block-latest-posts__post-excerpt\">VS Code feature WindowsTerminal Vs Code Features using multiple cursors<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/09\/24\/inspecting-function-subtypes-in-power-query\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2022\/09\/image-8-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/09\/24\/inspecting-function-subtypes-in-power-query\/\">Inspecting Function &#8220;subtypes&#8221; in Power Query<\/a><time datetime=\"2022-09-24T10:46:18-05:00\" class=\"wp-block-latest-posts__post-date\">2022-09-24<\/time><div class=\"wp-block-latest-posts__post-excerpt\">PowerQuery has metadata that you don&#8217;t normally see. For example, take the function Table.FromRecords Create a new blank query, and set the value to a function&#8217;s name. When you reference a function without arguments or parenthesis, it displays documentation. ( It&#8217;s mostly the same as the online docs ) Where does this come from? A [&hellip;]<\/div><\/li>\n<li><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/09\/11\/experiments-of-2022-09\/\">Experiments of 2022-09<\/a><time datetime=\"2022-09-11T09:23:31-05:00\" class=\"wp-block-latest-posts__post-date\">2022-09-11<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Power BI \/ Power Query Things to note options is an record, when used this way it&#8217;s similar to Python&#8217;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&#8217;t change the final result (order of execution is the same) [&hellip;]<\/div><\/li>\n<li><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/08\/13\/experiments-of-2022-08\/\">Experiments of 2022-08<\/a><time datetime=\"2022-08-13T10:55:38-05:00\" class=\"wp-block-latest-posts__post-date\">2022-08-13<\/time><div class=\"wp-block-latest-posts__post-excerpt\">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&#8217;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 [&hellip;]<\/div><\/li>\n<li><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/06\/29\/animations-of-2022-07\/\">Animations of 2022-07<\/a><time datetime=\"2022-06-29T09:34:14-05:00\" class=\"wp-block-latest-posts__post-date\">2022-06-29<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Single File With Automatic Inline Testing Addon: https:\/\/marketplace.visualstudio.com\/items?itemName=pspester.pester-test Plus Error Lens<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/05\/01\/viewing-default-settings-in-vs-code\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2022\/04\/vscode-finding-changing-default-settings-2022-04.go-symbol-part1-1-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/05\/01\/viewing-default-settings-in-vs-code\/\">Viewing Default Settings in VS Code<\/a><time datetime=\"2022-05-01T15:44:48-05:00\" class=\"wp-block-latest-posts__post-date\">2022-05-01<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Where is the default settings.json or keybindings.json ? There isn&#8217;t one, because it&#8217;s dynamically generated. When you run run the &#8216;default settings&#8217; command, it builds a new one &#8212; this means it&#8217;s always up to date. It includes settings from all enabled addons. Command Palette: The Only Hotkey You Need to Remember. Can&#8217;t remember what [&hellip;]<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/04\/14\/experiments-of-2022-04\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2021\/10\/parsing-whitespace-\u2510-commandline-\u2510-using-lizards-2021-10-24-1-150x150.gif\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/04\/14\/experiments-of-2022-04\/\">Experiments of 2022-04<\/a><time datetime=\"2022-04-14T14:25:08-05:00\" class=\"wp-block-latest-posts__post-date\">2022-04-14<\/time><div class=\"wp-block-latest-posts__post-excerpt\">FdFind, Ansi Colors with Group-Object Using wt&#8216;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<\/div><\/li>\n<li><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/03\/03\/how-do-i-get-started-in-power-apps-with-cheat-sheets\/\">How Do I Get Started with Power Apps? With Cheat Sheets<\/a><time datetime=\"2022-03-03T21:57:07-06:00\" class=\"wp-block-latest-posts__post-date\">2022-03-03<\/time><div class=\"wp-block-latest-posts__post-excerpt\">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 &#8211; Declaring Inline Tables Step1: Choose Insert -&gt; Button. Step2: Set the button&#8217;s OnSelect property to this. Step3: Alt left click the [&hellip;]<\/div><\/li>\n<li><a href=\"https:\/\/ninmonkeys.com\/blog\/2022\/02\/20\/experiments-answers-of-2022-02\/\">Experiments \/ Answers of 2022-02<\/a><time datetime=\"2022-02-20T11:16:22-06:00\" class=\"wp-block-latest-posts__post-date\">2022-02-20<\/time><div class=\"wp-block-latest-posts__post-excerpt\">File Selection CLI Revisiting BASH See more Detect Valid Values for gh &#8211;json &#8212; 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 [&hellip;]<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/10\/11\/experiments-of-2021-10\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2021\/10\/Pwsh-Select-Colors-2021-09-04--150x150.gif\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/10\/11\/experiments-of-2021-10\/\">Experiments of 2021-10<\/a><time datetime=\"2021-10-11T11:29:45-05:00\" class=\"wp-block-latest-posts__post-date\">2021-10-11<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Experiments: DAX, Pwsh, VS Code<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/02\/26\/run-dax-in-your-browser-sql-bi-com-has-a-dax-web-app-whats-new\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2021\/02\/image-19-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/02\/26\/run-dax-in-your-browser-sql-bi-com-has-a-dax-web-app-whats-new\/\">Run DAX in Your Browser: SQL-BI.com has a DAX Web App | What&#8217;s New<\/a><time datetime=\"2021-02-26T20:54:58-06:00\" class=\"wp-block-latest-posts__post-date\">2021-02-26<\/time><div class=\"wp-block-latest-posts__post-excerpt\"><a href=\"https:\/\/www.sqlbi.com\/blog\/marco\/2021\/02\/17\/introducing-dax-do\/ \">Dax Web App<\/a> ( From sqlbi.com )<\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/02\/12\/word-wrapping-text-in-power-query\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2021\/02\/2021-02-dynamically-wrap-text-without-breaking-words-nicer-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/02\/12\/word-wrapping-text-in-power-query\/\">Word Wrapping Text in Power Query<\/a><time datetime=\"2021-02-12T23:06:21-06:00\" class=\"wp-block-latest-posts__post-date\">2021-02-12<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Word wrapping text using <code>List.Accumulate<\/code> and <code>Occurrence.Last<\/code><span class=\"simple-icon-powerbi\" style=\"fill:#F2C811;\"><svg role=\"img\" viewBox=\"0 0 24 24\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><title>Power BI<\/title><path d=\"M21 1v22a1 1 0 0 1-1 1h-3.5V7c0-.827-.673-1.5-1.5-1.5h-2V1a1 1 0 0 1 1-1h6a1 1 0 0 1 1 1zm-6 5H9a1 1 0 0 0-1 1v4.5h2c.827 0 1.5.673 1.5 1.5v11H16V7a1 1 0 0 0-1-1zm-5 6H4a1 1 0 0 0-1 1v10a1 1 0 0 0 1 1h7V13a1 1 0 0 0-1-1z\" \/><\/svg><\/span><\/div><\/li>\n<li><div class=\"wp-block-latest-posts__featured-image aligncenter\"><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/01\/31\/power-query-custom-functions-cheat-sheet\/\"><img width=\"150\" height=\"150\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2021\/01\/temp-1-150x150.png\" class=\"attachment-thumbnail size-thumbnail wp-post-image\" alt=\"\" loading=\"lazy\" style=\"max-width:150px;max-height:150px;\" \/><\/a><\/div><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/01\/31\/power-query-custom-functions-cheat-sheet\/\">Power Query Custom Functions &#8211; Cheat Sheet<\/a><time datetime=\"2021-01-31T17:22:54-06:00\" class=\"wp-block-latest-posts__post-date\">2021-01-31<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Declaring <code>optional parameters<\/code> in custom functions, combine <b>multiple<\/b> <code>Web.Contents<\/code> queries, <b>without refresh errors<\/b>. Using <code>Html.Table<\/code> with custom <code>CSS Selectors<\/code><\/div><\/li>\n<li><a href=\"https:\/\/ninmonkeys.com\/blog\/2021\/01\/27\/big-list-of-cheat-sheets-and-references\/\">Big List of Cheat sheets and References<\/a><time datetime=\"2021-01-27T10:24:53-06:00\" class=\"wp-block-latest-posts__post-date\">2021-01-27<\/time><div class=\"wp-block-latest-posts__post-excerpt\">Web Technologies, Specs, Programming, and Configuration<\/div><\/li>\n<\/ul>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"templates\/template-full-width.php","meta":[],"_links":{"self":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/pages\/1665"}],"collection":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/comments?post=1665"}],"version-history":[{"count":8,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/pages\/1665\/revisions"}],"predecessor-version":[{"id":1685,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/pages\/1665\/revisions\/1685"}],"wp:attachment":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/media?parent=1665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}