toc.md

File Listing

Dynamically built using PipeScript

Last updated: 2023-09-02 10:58:39Z

Images Only

Root | Up ⭡

• 9/2/2023 10:45:17 AM PQ Tip of the day -- Extracting RelativePath from url in Json ⁞ 2023-08-02 forumQuestions\img\PQ Tip of the day -- Extracting RelativePath from url in Json ⁞ 2023-08-02.png 19.88 kb
• 8/26/2023 3:58:45 PM Parse Json for dsnDiag Json\img\Parse Json for dsnDiag.png 78.09 kb
• 8/2/2023 8:02:11 PM PQ Tip of the day -- Dimension Tables using Table.Distinct ⁞ With Column Names ⁞ 2023-07-22 forumQuestions\img\PQ Tip of the day -- Dimension Tables using Table.Distinct ⁞ With Column Names ⁞ 2023-07-22.png 24.09 kb
• 6/26/2023 6:45:46 PM 2023-06-26 - Partial Text Contains forumQuestions\img\2023-06-26 - Partial Text Contains.png 19.20 kb
• 6/9/2023 6:21:05 PM 2023-06-06 - Dynamically Generating Urls forumQuestions\img\2023-06-06 - Dynamically Generating Urls.png 44.80 kb
• 6/4/2023 10:50:22 AM 2023-03-Dax_Explicitly_Format_Culture.pbix forumQuestions\img\2023-03-Dax_Explicitly_Format_Culture.pbix.png 65.97 kb
• 4/13/2023 10:52:12 PM SecurityCategory ⇢ unpivot and legends.2023.04 forumQuestions\img\SecurityCategory ⇢ unpivot and legends.2023.04.png 80.96 kb
• 4/6/2023 9:00:06 PM Dynamically Summing Columns by Names - 2023.03 Dynamic_Logic\img\Dynamically Summing Columns by Names - 2023.03.png 30.26 kb
• 3/21/2023 5:19:12 PM Finding-duplicates-using-groupby-or-table-distinct forumQuestions\img\Finding-duplicates-using-groupby-or-table-distinct.png 35.38 kb
• 3/3/2023 8:18:13 PM 2023-03_Import_Shifted_Columns forumQuestions\img\2023-03_Import_Shifted_Columns.png 47.10 kb
• 1/24/2023 5:33:18 PM discord ▸ Switch with Multiple Columns.2023-01.pbix misc\from_discord\img\discord ▸ Switch with Multiple Columns.2023-01.pbix.png 66.90 kb
• 1/22/2023 6:06:33 PM Lookup Permissions in a Dimension Table -- PQ Calculated Columns misc\img\Lookup Permissions in a Dimension Table -- PQ Calculated Columns.png 76.75 kb
• 1/16/2023 7:36:53 PM transform Json - extracting mixed tables Json\img\transform Json - extracting mixed tables.png 37.42 kb
• 1/13/2023 1:49:12 PM Replacements using Mapping Table misc\img\Replacements using Mapping Table.png 69.87 kb
• 1/6/2023 10:25:18 AM answering discord ┐⇽ Fillter newest NonBlank. 2022-12 misc\from_reddit\img\answering discord ┐⇽ Fillter newest NonBlank. 2022-12.png 81.24 kb
• 1/6/2023 10:05:10 AM answering discord ┐⇽ Fillter newest NonBlank. 2022-12-daxcode misc\from_reddit\img\answering discord ┐⇽ Fillter newest NonBlank. 2022-12-daxcode.png 192.40 kb
• 1/2/2023 10:56:10 PM multiple methods of getting Distinct Codes per year ┐2022-12 misc\from_discord\img\multiple methods of getting Distinct Codes per year ┐2022-12.png 50.79 kb
• 12/15/2022 10:16:28 AM Importing Numbers Using Culture Parameters Types\img\Importing Numbers Using Culture Parameters.png 27.87 kb
• 12/10/2022 9:57:19 PM filtering-nested-values-without-expanding-json Json\img\filtering-nested-values-without-expanding-json.png 25.43 kb
• 11/29/2022 9:13:29 PM using spaces in place of the thousands separator FormatStrings\img\using spaces in place of the thousands separator.png 87.89 kb
• 11/19/2022 7:09:03 PM edit-external-pq-from-excel Excel\img\edit-external-pq-from-excel.gif 172.10 kb
• 10/3/2022 8:43:24 PM Converting-Multiple-DateFormats-In-One-Column Types\img\Converting-Multiple-DateFormats-In-One-Column.png 25.59 kb
• 9/22/2022 10:26:08 AM Text.ReplacePartialMatch misc\img\Text.ReplacePartialMatch.mp4 87.30 kb
• 9/20/2022 6:19:37 PM testing-documentation-on-ascribed-type Types\img\testing-documentation-on-ascribed-type.png 260.75 kb
• 9/20/2022 5:38:23 PM joining-text as pipes from auto-coerced-column-values-01 Types\img\joining-text as pipes from auto-coerced-column-values-01.png 54.66 kb
• 9/16/2022 11:32:49 AM UsingStructuredErrors-ValidateQueryIsDistinct errorHandling\img\UsingStructuredErrors-ValidateQueryIsDistinct.png 51.29 kb
• 8/13/2022 10:25:38 AM Summarize ⁞ Queries ┐main_query Testing\img\Summarize ⁞ Queries ┐main_query.png 64.46 kb
• 7/22/2022 11:17:46 PM OData ⁞ Test a list of Queries WebRequests\OData\img\OData ⁞ Test a list of Queries.png 106.08 kb
• 7/11/2022 2:32:09 PM WebContents ⁞ Catch uncatchable Datasource errors┐main_query WebRequests\img\WebContents ⁞ Catch uncatchable Datasource errors┐main_query.png 53.25 kb

All Files

Root | Up ⭡

• 9/2/2023 10:58:35 AM readme forumQuestions\readme.md 5.76 kb
• 9/2/2023 10:46:45 AM PQ Tip of the day -- Extracting RelativePath from url in Json ⁞ 2023-08-02 forumQuestions\PQ Tip of the day -- Extracting RelativePath from url in Json ⁞ 2023-08-02.pbix 24.58 kb
• 9/2/2023 10:46:07 AM PQ Tip of the day -- Extracting RelativePath from url in Json ⁞ 2023-08-02 forumQuestions\pq\PQ Tip of the day -- Extracting RelativePath from url in Json ⁞ 2023-08-02.pq 1.07 kb
• 9/2/2023 10:45:17 AM PQ Tip of the day -- Extracting RelativePath from url in Json ⁞ 2023-08-02 forumQuestions\img\PQ Tip of the day -- Extracting RelativePath from url in Json ⁞ 2023-08-02.png 19.88 kb
• 8/29/2023 5:18:18 PM 2023-05-04 - Dates with Times as Ranges forumQuestions\pq\2023-05-04 - Dates with Times as Ranges.pq 5.55 kb
• 8/29/2023 10:19:42 AM Parse Json for dsnDiag Json\Parse Json for dsnDiag.pbix 37.62 kb
• 8/29/2023 9:38:54 AM Parse Json for dsnDiag Json\pq\Parse Json for dsnDiag.md 7.13 kb
• 8/27/2023 7:13:59 PM Enumerate all Power Query functions using shared Dynamic_Logic\pq\Enumerate all Power Query functions using shared.pq 1.65 kb
• 8/27/2023 7:11:52 PM Enumerate all Power Query functions using shared Dynamic_Logic\Enumerate all Power Query functions using shared.pbix 53.92 kb
• 8/27/2023 6:24:53 PM Parse Json for dsnDiag Json\pq\Parse Json for dsnDiag.pq 4.28 kb
• 8/26/2023 4:04:54 PM readme Json\readme.md 1.45 kb
• 8/26/2023 3:58:45 PM Parse Json for dsnDiag Json\img\Parse Json for dsnDiag.png 78.09 kb
• 8/24/2023 5:25:49 PM Dynamically Detect Current Folder of Workbook.2022.🎨 Excel\Dynamically Detect Current Folder of Workbook.2022.🎨.xlsx 23.88 kb
• 8/2/2023 8:02:11 PM PQ Tip of the day -- Dimension Tables using Table.Distinct ⁞ With Column Names ⁞ 2023-07-22 forumQuestions\img\PQ Tip of the day -- Dimension Tables using Table.Distinct ⁞ With Column Names ⁞ 2023-07-22.png 24.09 kb
• 6/26/2023 6:48:50 PM 2023-06-26 - Partial Text Contains forumQuestions\2023-06-26 - Partial Text Contains.pbix 25.18 kb
• 6/26/2023 6:48:26 PM 2023-06-26 - Partial Text Contains forumQuestions\pq\2023-06-26 - Partial Text Contains.pq 1.54 kb
• 6/26/2023 6:45:46 PM 2023-06-26 - Partial Text Contains forumQuestions\img\2023-06-26 - Partial Text Contains.png 19.20 kb
• 6/20/2023 4:03:09 PM compare-handling-errors-using-otherwise-vs-catch errorHandling\compare-handling-errors-using-otherwise-vs-catch.pbix 15.09 kb
• 6/20/2023 4:00:57 PM Using Structured Errors ⁞ custom errors errorHandling\Using Structured Errors ⁞ custom errors.pbix 20.10 kb
• 6/16/2023 9:21:25 PM 2023-06-10 - Odata Basics forumQuestions\2023-06-10 - Odata Basics.pbix 75.80 kb
• 6/12/2023 5:25:14 PM 2023-05-10 - Slice and Dice - Using Optional Parameters and Null coalesce operators.post forumQuestions\pq\2023-05-10 - Slice and Dice - Using Optional Parameters and Null coalesce operators.post.md 2.32 kb
• 6/12/2023 5:23:05 PM 2023_04-24 - group Id - find newest kittens forumQuestions\pq\2023_04-24 - group Id - find newest kittens.pq 2.47 kb
• 6/9/2023 9:35:18 PM 2023-06-06 - Dynamically Generating Urls forumQuestions\2023-06-06 - Dynamically Generating Urls.pbix 24.66 kb
• 6/9/2023 6:22:30 PM 2023-06-06 - Dynamically Generating Urls forumQuestions\dax\2023-06-06 - Dynamically Generating Urls.dax 0.45 kb
• 6/9/2023 6:21:05 PM 2023-06-06 - Dynamically Generating Urls forumQuestions\img\2023-06-06 - Dynamically Generating Urls.png 44.80 kb
• 6/9/2023 5:45:42 PM 2023-06-05 - Infraction Pie forumQuestions\2023-06-05 - Infraction Pie.pbix 29.88 kb
• 6/4/2023 11:39:50 AM 2023-03 - Dax Explicitly Format Culture forumQuestions\2023-03 - Dax Explicitly Format Culture.pbix 34.22 kb
• 6/4/2023 11:34:52 AM readme.ps forumQuestions\readme.ps.md 2.19 kb
• 6/4/2023 10:50:22 AM 2023-03-Dax_Explicitly_Format_Culture.pbix forumQuestions\img\2023-03-Dax_Explicitly_Format_Culture.pbix.png 65.97 kb
• 5/27/2023 3:09:39 PM toc toc.md 48.80 kb
• 5/14/2023 9:19:33 AM 2023-05-04 - Dates with Times as Ranges.Simplified forumQuestions\pq\2023-05-04 - Dates with Times as Ranges.Simplified.pq 1.61 kb
• 5/12/2023 3:23:10 PM 2023-05-10 - Slice and Dice - Using Optional Parameters and Null coalesce operators forumQuestions\2023-05-10 - Slice and Dice - Using Optional Parameters and Null coalesce operators.pbix 31.24 kb
• 5/12/2023 12:35:27 PM 2023-05-04 - Dates with Times as Ranges forumQuestions\2023-05-04 - Dates with Times as Ranges.pbix 28.05 kb
• 5/12/2023 12:31:09 PM toc.ps toc.ps.md 0.34 kb
• 5/9/2023 9:56:54 PM 2023-05-10 - Slice and Dice - Using Optional Parameters and Null coalesce operators forumQuestions\pq\2023-05-10 - Slice and Dice - Using Optional Parameters and Null coalesce operators.pq 1.40 kb
• 5/6/2023 4:24:25 PM 2023-05-06 - Unpivoted Student Grades forumQuestions\2023-05-06 - Unpivoted Student Grades.pbix 33.19 kb
• 4/25/2023 4:40:57 PM 2021_06-27 - Group by Id - Find Most Recently Modified Kitten forumQuestions\2021_06-27 - Group by Id - Find Most Recently Modified Kitten.pbix 32.95 kb
• 4/25/2023 3:45:41 PM filtering-nested-json Json\pq\filtering-nested-json.md 3.34 kb
• 4/15/2023 9:46:52 PM verify is duplicate --- SecurityCategory ⇢ unpivot and legends.2023.04 forumQuestions\verify is duplicate --- SecurityCategory ⇢ unpivot and legends.2023.04.pbix 27.39 kb
• 4/13/2023 11:25:55 PM SecurityCategory ⇢ unpivot and legends.2023.04 forumQuestions\SecurityCategory ⇢ unpivot and legends.2023.04.pbix 27.41 kb
• 4/13/2023 10:54:53 PM SecurityCategory ⇢ unpivot and legends.2023.04 forumQuestions\pq\SecurityCategory ⇢ unpivot and legends.2023.04.pq 1.18 kb
• 4/13/2023 10:52:12 PM SecurityCategory ⇢ unpivot and legends.2023.04 forumQuestions\img\SecurityCategory ⇢ unpivot and legends.2023.04.png 80.96 kb
• 4/6/2023 9:09:42 PM Text - Metadata.Table GetColumnNames ⁞ as SQL expression tabular\Text - Metadata.Table GetColumnNames ⁞ as SQL expression.md 0.60 kb
• 4/6/2023 9:00:06 PM Dynamically Summing Columns by Names - 2023.03 Dynamic_Logic\pq\Dynamically Summing Columns by Names - 2023.03.pq 1.18 kb
• 4/6/2023 9:00:06 PM Dynamically Summing Columns by Names - 2023.03 Dynamic_Logic\img\Dynamically Summing Columns by Names - 2023.03.png 30.26 kb
• 4/6/2023 9:00:06 PM Dynamically Summing Columns by Names - 2023.03 Dynamic_Logic\Dynamically Summing Columns by Names - 2023.03.pbix 40.17 kb
• 3/23/2023 7:01:43 PM 2023-03 - Contoso forumQuestions\2023-03 - Contoso .pbix 1,301.52 kb
• 3/21/2023 5:39:28 PM Are Records Unique Question ⇢ Using Table.Group - 2023.03 forumQuestions\Are Records Unique Question ⇢ Using Table.Group - 2023.03.pbix 24.13 kb
• 3/21/2023 5:19:12 PM Finding-duplicates-using-groupby-or-table-distinct forumQuestions\img\Finding-duplicates-using-groupby-or-table-distinct.png 35.38 kb
• 3/21/2023 5:16:31 PM Finding-duplicates-using-groupby-or-table-distinct forumQuestions\pq\Finding-duplicates-using-groupby-or-table-distinct.pq 0.88 kb
• 3/20/2023 8:06:41 PM Concept ⁞ Let Expressions Are Record Expressions ┐part2.pq Power-Query-For-Programmers\items\Concept ⁞ Let Expressions Are Record Expressions ┐part2.pq.md 0.58 kb
• 3/20/2023 8:00:00 PM Concept ⁞ Let Expressions Are Record Expressions ┐part1.pq Power-Query-For-Programmers\items\Concept ⁞ Let Expressions Are Record Expressions ┐part1.pq.md 0.25 kb
• 3/20/2023 7:55:13 PM example how to correctly declare AddColumn with types -- using a nested JSON value.pq sketches\example how to correctly declare AddColumn with types -- using a nested JSON value.pq.md 3.33 kb
• 3/20/2023 7:55:13 PM LookUp user ID and permissions table - Experimenting.2023-01 sketches\dax\LookUp user ID and permissions table - Experimenting.2023-01.dax 0.53 kb
• 3/20/2023 7:55:13 PM FirstBlanks Demo - Experimenting filters sketches\dax\FirstBlanks Demo - Experimenting filters.dax 2.00 kb
• 3/20/2023 7:55:13 PM FirstBlanks Demo - Experimenting filters-file3 sketches\dax\FirstBlanks Demo - Experimenting filters-file3.dax 3.70 kb
• 3/20/2023 7:55:13 PM FirstBlanks Demo - Experimenting filters-file2 sketches\dax\FirstBlanks Demo - Experimenting filters-file2.dax 1.29 kb
• 3/20/2023 7:55:13 PM answering reddit -- generating path ids.2022-11 sketches\answering reddit -- generating path ids.2022-11.pbix 28.43 kb
• 3/20/2023 7:55:13 PM answering discord -- format strings using spaces.2022-11 sketches\answering discord -- format strings using spaces.2022-11.pbix 18.86 kb
• 3/20/2023 7:55:13 PM grab for named unistr emojis -- utils ⁞ InspectBinary bytes and text encoding 🔍🔎 ┐ 2021-02-14 sketch\grab for named unistr emojis -- utils ⁞ InspectBinary bytes and text encoding 🔍🔎 ┐ 2021-02-14.pbix 45.44 kb
• 3/20/2023 7:55:13 PM Getting Earlier Rows in DAX ⁞ without using Earlier ┐ 2023-02-14 sketch\dax\Getting Earlier Rows in DAX ⁞ without using Earlier ┐ 2023-02-14.dax 1.05 kb
• 3/20/2023 7:55:13 PM codepoints-of-words-📌2022-02-iter0 sketch\codepoints-of-words-📌2022-02-iter0.pbix 44.70 kb
• 3/20/2023 7:55:13 PM almost done -- visualize runes and codepoints and bytes inspect text codepoints - 2022-06-14 sketch\almost done -- visualize runes and codepoints and bytes inspect text codepoints - 2022-06-14.pbix 36.57 kb
• 3/20/2023 7:55:13 PM Safety_Reports_-_PowerB.2 pbix sketch\Safety_Reports_-_PowerB.2 pbix.xlsx 1,544.32 kb
• 3/20/2023 7:55:13 PM Getting Earlier Rows in DAX ⁞ without using Earlier ┐ 2023-02-14 sketch\Getting Earlier Rows in DAX ⁞ without using Earlier ┐ 2023-02-14.pbix 20.45 kb
• 3/20/2023 7:55:13 PM 2023-02 - Table.TransformMany.example.pbbix sketch\2023-02 - Table.TransformMany.example.pbbix.pbix 14.27 kb
• 3/20/2023 7:55:13 PM 2023-02 - Table.TransformMany.example.v2 sketch\2023-02 - Table.TransformMany.example.v2.pbix 21.36 kb
• 3/20/2023 7:55:13 PM 2022-12 - grouping words as categories sketch\2022-12 - grouping words as categories.pbix 37.55 kb
• 3/20/2023 7:55:13 PM 2022-04 - 📌Unicode info to DAX using nested variables sketch\2022-04 - 📌Unicode info to DAX using nested variables.pbix 1,894.01 kb
• 3/20/2023 7:55:13 PM 2022-04 - preserving error info - using catch not otherwise.2 sketch\2022-04 - preserving error info - using catch not otherwise.2.pbix 16.00 kb
• 3/20/2023 7:55:13 PM 2022-04 - grid cost.4 sketch\2022-04 - grid cost.4.pbix 344.85 kb
• 3/20/2023 7:55:13 PM 2022-04 - grid cost.3 sketch\2022-04 - grid cost.3.pbix 342.28 kb
• 3/20/2023 7:55:13 PM 2022-04 - grid cost.2 sketch\2022-04 - grid cost.2.pbix 209.37 kb
• 3/20/2023 7:55:13 PM 2022-04 - download-poorly-named-urls sketch\2022-04 - download-poorly-named-urls.pbix 35.30 kb
• 3/20/2023 7:55:13 PM 2022-04 - Basic JSON schema -- web api sketch\2022-04 - Basic JSON schema -- web api.pbix 66.97 kb
• 3/20/2023 7:55:13 PM Inspecting Metadata -- enumerate all PowerQuery functions misc\pq\Inspecting Metadata -- enumerate all PowerQuery functions.pq 1.60 kb
• 3/20/2023 7:55:13 PM ForEach - Looping over two lists -- cartesian join misc\pq\ForEach - Looping over two lists -- cartesian join.pbix 0.77 kb
• 3/20/2023 7:55:13 PM discord ▸ Switch with Multiple Columns.2023-01 misc\from_discord\discord ▸ Switch with Multiple Columns.2023-01.pbix 21.48 kb
• 3/20/2023 7:55:13 PM Grouping Subgroups not unlike sql window functions misc\dump\Grouping Subgroups not unlike sql window functions.pbix 18.03 kb
• 3/20/2023 7:55:13 PM TransformMany - Creating Tables misc\TransformMany - Creating Tables.pbix 25.90 kb
• 3/20/2023 7:55:13 PM ToCsv - Join Any Types as CSV misc\ToCsv - Join Any Types as CSV.pbix 18.85 kb
• 3/20/2023 7:55:13 PM ForEach - Looping over two lists -- cartesian join misc\ForEach - Looping over two lists -- cartesian join.pbix 16.16 kb
• 3/20/2023 7:55:13 PM basic.web.contents.invoke.pattern WebRequests\pq\basic.web.contents.invoke.pattern.pq 0.61 kb
• 3/20/2023 7:55:13 PM Simplify parsing HTML using CSS Selector Queries ⁞ Dom Query.2023-02 WebRequests\pq\Simplify parsing HTML using CSS Selector Queries ⁞ Dom Query.2023-02.pq 3.10 kb
• 3/20/2023 7:55:13 PM Using Table Columns ⁞ For WebRequest Query Strings.2023.02 WebRequests\Using Table Columns ⁞ For WebRequest Query Strings.2023.02.pbix 15.83 kb
• 3/20/2023 7:55:13 PM Simplify parsing HTML using CSS Selector Queries ⁞ Dom Query.2023-02 WebRequests\Simplify parsing HTML using CSS Selector Queries ⁞ Dom Query.2023-02.pbix 20.28 kb
• 3/20/2023 7:55:13 PM Detecting SSL Errors with WebContents ⁞ Sample SSL Errors.2023-01 WebRequests\Detecting SSL Errors with WebContents ⁞ Sample SSL Errors.2023-01.pbix 39.28 kb
• 3/20/2023 7:55:13 PM del me Unicode\del me.pbix 9,471.79 kb
• 3/20/2023 7:55:13 PM date table - sample ⁞ example ┐ power queryas pbix ┐ 2021-11-01 Unicode\date table - sample ⁞ example ┐ power queryas pbix ┐ 2021-11-01.pbix 144.92 kb
• 3/20/2023 7:55:13 PM basic date table - power query.2022-11-01 Unicode\basic date table - power query.2022-11-01.pbix 144.86 kb
• 3/20/2023 7:55:13 PM Retail Analysis Sample PBIX2 Unicode\Retail Analysis Sample PBIX2.pbix 9,481.51 kb
• 3/20/2023 7:55:13 PM Animals ⇽ Using Unicode Lookup Mapping Table for Symbols.2023-01 Unicode\Animals ⇽ Using Unicode Lookup Mapping Table for Symbols.2023-01.pbix 34.08 kb
• 3/20/2023 7:55:13 PM Transform Json - Extracting Tables from Mixed Json Json\Transform Json - Extracting Tables from Mixed Json.pbix 34.08 kb
• 3/20/2023 7:55:13 PM game log - 2022.12 Importing Data\game log - 2022.12.pbix 20.95 kb
• 3/20/2023 7:55:13 PM game log - 2022.12 - iter2 Importing Data\game log - 2022.12 - iter2.pbix 26.89 kb
• 3/20/2023 7:55:13 PM sketch - testing queries with blanks in dax Importing Data\dax\sketch - testing queries with blanks in dax.dax 0.44 kb
• 3/20/2023 7:55:13 PM sketch - testing queries with blanks in dax - page1 Importing Data\dax\sketch - testing queries with blanks in dax - page1.dax 0.42 kb
• 3/20/2023 7:55:13 PM Importing Date Time Zones - Round Trip Importing Data\Importing Date Time Zones - Round Trip.pbix 26.82 kb
• 3/20/2023 7:55:13 PM Blanks - Potentially Unexpected Implicit Coercsions.2022.12 - iter2 Importing Data\Blanks - Potentially Unexpected Implicit Coercsions.2022.12 - iter2.pbix 18.63 kb
• 3/20/2023 7:55:13 PM 2022-04 - How to Import Numbers Safely Without Errors Importing Data\2022-04 - How to Import Numbers Safely Without Errors.pbix 13.80 kb
• 3/20/2023 7:52:39 PM OData ⁞ Test a list of Queries WebRequests\OData\OData ⁞ Test a list of Queries.pbix 109.12 kb
• 3/20/2023 7:52:39 PM compare-handling-errors-using-otherwise-vs-catch errorHandling\pq\compare-handling-errors-using-otherwise-vs-catch.pq 3.10 kb
• 3/20/2023 7:51:27 PM About_LocalVariables.md Power-Query-For-Programmers\About_LocalVariables.md.pq 0.81 kb
• 3/20/2023 7:51:27 PM readme Power-Query-For-Programmers\readme.md 7.71 kb
• 3/3/2023 11:44:25 PM Filtering Multiple Conditions Using Custom Functions misc\from_discord\pq\Filtering Multiple Conditions Using Custom Functions.pq 1.14 kb
• 3/3/2023 9:27:30 PM index index.md 0.00 kb
• 3/3/2023 8:19:56 PM 2023-03 - Import Shifted Columns forumQuestions\2023-03 - Import Shifted Columns.pbix 33.17 kb
• 3/3/2023 8:18:13 PM 2023-03_Import_Shifted_Columns forumQuestions\img\2023-03_Import_Shifted_Columns.png 47.10 kb
• 3/3/2023 8:12:15 PM 2023-03 - Import Shifted Columns forumQuestions\pq\2023-03 - Import Shifted Columns.pq 0.89 kb
• 2/18/2023 4:21:36 PM New Dax Functions ▸ from 2022-12 ⁞ Index - EvaluateAndLog - ToJson - ToCsv Reference.Cheatsheet\New Dax Functions ▸ from 2022-12 ⁞ Index - EvaluateAndLog - ToJson - ToCsv.md 3.63 kb
• 2/13/2023 5:21:44 PM Reference.Summarized Function Extended Metadata.pq sketch\Reference.Summarized Function Extended Metadata.pq.md 1.49 kb
• 2/13/2023 5:21:44 PM Duration.FromSeconds and Milliseconds misc\pq\Duration.FromSeconds and Milliseconds.pq 0.64 kb
• 2/13/2023 5:21:44 PM Using Sections And Shared - Find Identifiers not lowercase Testing\pq\Using Sections And Shared - Find Identifiers not lowercase.pq 1.26 kb
• 1/28/2023 9:03:46 PM wip 🎨 Inspecting Metadata -- enumerate all PowerQuery functions in the environment.2023 misc\wip 🎨 Inspecting Metadata -- enumerate all PowerQuery functions in the environment.2023.pbix 39.19 kb
• 1/24/2023 5:54:39 PM readme misc\from_discord\readme.md 0.99 kb
• 1/24/2023 5:46:04 PM readme misc\readme.md 2.36 kb
• 1/24/2023 5:33:18 PM discord ▸ Switch with Multiple Columns.2023-01.pbix misc\from_discord\img\discord ▸ Switch with Multiple Columns.2023-01.pbix.png 66.90 kb
• 1/24/2023 5:32:34 PM discord ▸ Switch with Multiple Columns.2023-01 misc\from_discord\dax\discord ▸ Switch with Multiple Columns.2023-01.dax 1.59 kb
• 1/22/2023 9:50:51 PM Text.Inspect Unicode\pq\Text.Inspect.pq 1.92 kb
• 1/22/2023 9:49:36 PM Text.Inspect.full_example Unicode\pq\Text.Inspect.full_example.pq 4.27 kb
• 1/22/2023 9:45:43 PM Animals ⇽ Using Unicode Lookup Mapping Table for Symbols.2023-01.pq Unicode\pq\Animals ⇽ Using Unicode Lookup Mapping Table for Symbols.2023-01.pq.md 7.18 kb
• 1/22/2023 6:12:38 PM Transform Json - Extracting Tables from Mixed Json Json\pq\Transform Json - Extracting Tables from Mixed Json.md 5.84 kb
• 1/22/2023 6:10:34 PM Lookup Permissions in a Dimension Table -- PQ Calculated Columns misc\Lookup Permissions in a Dimension Table -- PQ Calculated Columns.pbix 28.91 kb
• 1/22/2023 6:06:33 PM Lookup Permissions in a Dimension Table -- PQ Calculated Columns misc\img\Lookup Permissions in a Dimension Table -- PQ Calculated Columns.png 76.75 kb
• 1/22/2023 6:02:15 PM Lookup Permissions in a Dimension Table -- PQ Calculated Columns.pq misc\pq\Lookup Permissions in a Dimension Table -- PQ Calculated Columns.pq.md 3.12 kb
• 1/16/2023 7:50:49 PM readme readme.md 0.98 kb
• 1/16/2023 7:36:53 PM transform Json - extracting mixed tables Json\img\transform Json - extracting mixed tables.png 37.42 kb
• 1/14/2023 3:54:46 PM readme errorHandling\readme.md 1.68 kb
• 1/14/2023 3:28:45 PM sketch -maybe duplicate 2023 - duplicate errorHandling\sketch -maybe duplicate 2023 - duplicate.pbix 15.49 kb
• 1/14/2023 12:37:42 PM sketch of better string error formatting.2023-01 sketches\sketch of better string error formatting.2023-01.pbix 29.54 kb
• 1/13/2023 6:55:00 PM Replacements using Mapping Table misc\Replacements using Mapping Table.pbix 21.97 kb
• 1/13/2023 1:49:12 PM Replacements using Mapping Table misc\img\Replacements using Mapping Table.png 69.87 kb
• 1/13/2023 1:38:36 PM Replacements using Mapping Table.query - mapping table misc\pq\Replacements using Mapping Table.query - mapping table.pq 0.35 kb
• 1/13/2023 1:38:03 PM Replacements using Mapping Table.query - main misc\pq\Replacements using Mapping Table.query - main.pq 0.50 kb
• 1/13/2023 1:36:53 PM Replacements using Mapping Table.function - Text.ReplacePartialMatches misc\pq\Replacements using Mapping Table.function - Text.ReplacePartialMatches.pq 1.23 kb
• 1/13/2023 1:21:55 PM joining-text as pipes from auto-coerced-column-values misc\pq\joining-text as pipes from auto-coerced-column-values.pq 5.31 kb
• 1/13/2023 1:20:35 PM 🐒 github.comⳆninmonkey ▸ 2022-12 misc\🐒 github.comⳆninmonkey ▸ 2022-12.pbix 110.01 kb
• 1/10/2023 8:00:16 PM Animals ⇽ Using Unicode Lookup Mapping Table for Symbols.2023-01 Unicode\dax\Animals ⇽ Using Unicode Lookup Mapping Table for Symbols.2023-01.dax 0.38 kb
• 1/10/2023 7:31:59 PM answering discord ┐⇽ zoo - animal species and filtering groups of.2022-12 misc\from_reddit\answering discord ┐⇽ zoo - animal species and filtering groups of.2022-12.pbix 27.40 kb
• 1/6/2023 8:22:36 PM answering discord ┐⇽ dax offset ranking.pokemon.2022-12 misc\from_reddit\answering discord ┐⇽ dax offset ranking.pokemon.2022-12.pbix 26.87 kb
• 1/6/2023 7:13:35 PM Index and Partitions - Experimenting filters-file4 sketches\dax\Index and Partitions - Experimenting filters-file4.dax 0.82 kb
• 1/6/2023 7:13:26 PM Index and Partitions - Experimenting filters-file3 sketches\dax\Index and Partitions - Experimenting filters-file3.dax 0.82 kb
• 1/6/2023 3:39:25 PM answering discord ┐⇽ dax window function. 2022-12 misc\from_reddit\answering discord ┐⇽ dax window function. 2022-12.pbix 25.67 kb
• 1/6/2023 10:26:07 AM answering discord ┐⇽ Fillter newest NonBlank. 2022-12 misc\from_reddit\answering discord ┐⇽ Fillter newest NonBlank. 2022-12.pbix 110.06 kb
• 1/6/2023 10:25:18 AM answering discord ┐⇽ Fillter newest NonBlank. 2022-12 misc\from_reddit\img\answering discord ┐⇽ Fillter newest NonBlank. 2022-12.png 81.24 kb
• 1/6/2023 10:17:41 AM del - answering discord ┐⇽ Fillter newest NonBlank. 2022-12 misc\from_reddit\del - answering discord ┐⇽ Fillter newest NonBlank. 2022-12.pbix 110.06 kb
• 1/6/2023 10:05:10 AM answering discord ┐⇽ Fillter newest NonBlank. 2022-12-daxcode misc\from_reddit\img\answering discord ┐⇽ Fillter newest NonBlank. 2022-12-daxcode.png 192.40 kb
• 1/2/2023 11:30:57 PM sketch.multiple methods of getting Distinct Codes per year ┐2022-12 misc\from_discord\sketch.multiple methods of getting Distinct Codes per year ┐2022-12.pbix 31.89 kb
• 1/2/2023 11:03:47 PM answering discord ┐⇽ Fillter newest NonBlank. 2022-12.dax misc\from_reddit\dax\answering discord ┐⇽ Fillter newest NonBlank. 2022-12.dax.md 1.38 kb
• 1/2/2023 11:01:39 PM multiple_distinct_examples misc\from_discord\pq\multiple_distinct_examples.md 2.68 kb
• 1/2/2023 10:56:10 PM multiple methods of getting Distinct Codes per year ┐2022-12 misc\from_discord\img\multiple methods of getting Distinct Codes per year ┐2022-12.png 50.79 kb
• 1/2/2023 10:48:16 PM multiple methods of getting Distinct Codes per year ┐2022-12 misc\from_discord\multiple methods of getting Distinct Codes per year ┐2022-12.pbix 23.58 kb
• 12/31/2022 12:54:35 PM unpivot ⇽ from almost-pivoted-data.2022-12 misc\from_reddit\unpivot ⇽ from almost-pivoted-data.2022-12.pbix 20.47 kb
• 12/31/2022 12:51:39 PM unpivot ⇽ from almost-pivoted-data.2022-12 misc\from_reddit\pq\unpivot ⇽ from almost-pivoted-data.2022-12.pq 1.80 kb
• 12/18/2022 10:37:49 AM From Abbreviated Month Names Importing Data\From Abbreviated Month Names.pbix 17.47 kb
• 12/15/2022 11:06:15 AM How to Import Numbers Safely Without Errors - using Culture Types\How to Import Numbers Safely Without Errors - using Culture.pbix 18.88 kb
• 12/15/2022 11:04:16 AM readme Types\readme.md 3.66 kb
• 12/15/2022 10:16:28 AM Importing Numbers Using Culture Parameters Types\img\Importing Numbers Using Culture Parameters.png 27.87 kb
• 12/15/2022 10:14:27 AM Importing Numbers Using Culture Parameters Types\pq\Importing Numbers Using Culture Parameters.pq 0.93 kb
• 12/13/2022 7:18:46 PM Dynamically Detect Current Folder of Workbook.2022 Excel\Dynamically Detect Current Folder of Workbook.2022.xlsx 8.64 kb
• 12/12/2022 2:03:23 PM todo Excel\todo.md 1.28 kb
• 12/10/2022 10:43:52 PM readme FormatStrings\readme.md 0.87 kb
• 12/10/2022 10:37:38 PM Filter Json - Filtering Nested Values Without Expanding values Json\Filter Json - Filtering Nested Values Without Expanding values.pbix 27.51 kb
• 12/10/2022 9:57:19 PM filtering-nested-values-without-expanding-json Json\img\filtering-nested-values-without-expanding-json.png 25.43 kb
• 12/7/2022 6:24:43 PM 2022-12 - grouping words as categories sketch\2022-12 - grouping words as categories.pq 5.74 kb
• 11/29/2022 9:17:00 PM format currency - using spaces in place of the thousands separator.2022-12 FormatStrings\format currency - using spaces in place of the thousands separator.2022-12.pbix 19.04 kb
• 11/29/2022 9:16:50 PM using spaces in place of the thousands separator FormatStrings\dax\using spaces in place of the thousands separator.dax 0.66 kb
• 11/29/2022 9:13:29 PM using spaces in place of the thousands separator FormatStrings\img\using spaces in place of the thousands separator.png 87.89 kb
• 11/28/2022 7:44:13 AM Table Selection Syntax.reference Reference.Cheatsheet\Table Selection Syntax.reference.md 0.76 kb
• 11/27/2022 9:10:08 PM readme Excel\readme.md 0.51 kb
• 11/19/2022 7:20:23 PM ImportPQ.FromFile Excel\pq\ImportPQ.FromFile.pq 0.71 kb
• 11/19/2022 7:07:34 PM Edit external .pq files to refresh Excel.2022-11 Excel\Edit external .pq files to refresh Excel.2022-11.xlsx 16.84 kb
• 11/19/2022 7:05:39 PM external-script Excel\pq\external-script.pq 0.37 kb
• 11/13/2022 3:53:19 AM Text.InspectCodepoints Unicode\Text.InspectCodepoints.pq 0.75 kb
• 11/13/2022 3:49:29 AM Safely Render UniChar in DAX - PQ Inspect Unicode Byte Strings from different Encodings⁞2022-04 Unicode\Safely Render UniChar in DAX - PQ Inspect Unicode Byte Strings from different Encodings⁞2022-04.pbix 36,855.07 kb
• 11/13/2022 3:30:07 AM Unicode.GenerateRange Unicode\pq\Unicode.GenerateRange.pq 3.30 kb
• 11/13/2022 3:29:15 AM Safely Render UniChar -- replacing with symbols Unicode\dax\Safely Render UniChar -- replacing with symbols.dax 1.80 kb
• 11/11/2022 4:08:37 PM 2022-04 - grid cost.3 sketch\2022-04 - grid cost.3.pq 0.68 kb
• 10/3/2022 8:44:28 PM Converting-Multiple-DateFormats-In-One-Column Types\Converting-Multiple-DateFormats-In-One-Column.pbix 23.44 kb
• 10/3/2022 8:44:26 PM Converting-Multiple-DateFormats-In-One-Column Types\pq\Converting-Multiple-DateFormats-In-One-Column.pq 1.41 kb
• 10/3/2022 8:43:24 PM Converting-Multiple-DateFormats-In-One-Column Types\img\Converting-Multiple-DateFormats-In-One-Column.png 25.59 kb
• 9/22/2022 8:35:22 AM To BitString - FromDax sketches\To BitString - FromDax.md 4.00 kb
• 9/20/2022 6:24:40 PM joining-text as pipes from auto-coerced-column-values Types\pq\joining-text as pipes from auto-coerced-column-values.pq 5.92 kb
• 9/20/2022 6:24:25 PM joining-text as pipes from auto-coerced-column-values Types\joining-text as pipes from auto-coerced-column-values.pbix 22.57 kb
• 9/20/2022 6:19:37 PM testing-documentation-on-ascribed-type Types\img\testing-documentation-on-ascribed-type.png 260.75 kb
• 9/20/2022 5:38:23 PM joining-text as pipes from auto-coerced-column-values-01 Types\img\joining-text as pipes from auto-coerced-column-values-01.png 54.66 kb
• 9/16/2022 11:48:52 AM UsingStructuredErrors-ValidateQueryIsDistinct errorHandling\pq\UsingStructuredErrors-ValidateQueryIsDistinct.pq 1.63 kb
• 9/16/2022 11:32:49 AM UsingStructuredErrors-ValidateQueryIsDistinct errorHandling\img\UsingStructuredErrors-ValidateQueryIsDistinct.png 51.29 kb
• 8/18/2022 10:26:18 AM Summarize-All-Queries Testing\pq\Summarize-All-Queries.pq 2.46 kb
• 8/14/2022 8:28:00 PM Example-Diagnostics-Usage imports\Example-Diagnostics-Usage.pq 7.05 kb
• 8/14/2022 8:22:42 PM Diagnostics imports\Diagnostics.pq 19.16 kb
• 8/13/2022 10:40:40 AM Import-Cached-File-Listing FilesFolders\Import-Cached-File-Listing.md 1.79 kb
• 8/13/2022 10:28:23 AM readme Testing\readme.md 0.41 kb
• 8/13/2022 10:25:38 AM Summarize ⁞ Queries ┐main_query Testing\img\Summarize ⁞ Queries ┐main_query.png 64.46 kb
• 8/12/2022 8:23:53 PM main-query-to-invoke-test sketch\main-query-to-invoke-test.pq 1.77 kb
• 8/11/2022 4:02:57 PM unit test table constructor args ⁞ test runner ┐ 2022-08-05- iter1 Testing\unit test table constructor args ⁞ test runner ┐ 2022-08-05- iter1.pbix 31.87 kb
• 8/8/2022 6:08:09 PM WIP-jakeIter1 WIP-jakeIter1.pbix 37.14 kb
• 7/22/2022 11:20:13 PM readme WebRequests\OData\readme.md 0.30 kb
• 7/22/2022 11:17:46 PM OData ⁞ Test a list of Queries WebRequests\OData\img\OData ⁞ Test a list of Queries.png 106.08 kb
• 7/22/2022 11:01:42 PM OData ⁞ Test a list of Queries WebRequests\OData\pq\OData ⁞ Test a list of Queries.pq 2.09 kb
• 7/22/2022 10:52:58 PM sketch.OData ⁞ Test a list of Queries -iter2 WebRequests\OData\sketch.OData ⁞ Test a list of Queries -iter2.pbix 112.93 kb
• 7/22/2022 10:29:22 PM sketch.OData ⁞ Test a list of Queries WebRequests\OData\sketch.OData ⁞ Test a list of Queries.pbix 113.35 kb
• 7/18/2022 12:03:54 AM Alternate ways to declare strings ⁞ power query string functions ┐2022-07-16 Unicode\Alternate ways to declare strings ⁞ power query string functions ┐2022-07-16.pbix 14.69 kb
• 7/11/2022 3:29:54 PM WebContents ⁞ Catch uncatchable Datasource errors┐main_query WebRequests\pq\WebContents ⁞ Catch uncatchable Datasource errors┐main_query.pq 2.55 kb
• 7/11/2022 2:48:20 PM readme WebRequests\readme.md 0.58 kb
• 7/11/2022 2:40:21 PM WebContents ⁞ Catch uncatchable Datasource errors WebRequests\WebContents ⁞ Catch uncatchable Datasource errors.pbix 21.33 kb
• 7/11/2022 2:32:09 PM WebContents ⁞ Catch uncatchable Datasource errors┐main_query WebRequests\img\WebContents ⁞ Catch uncatchable Datasource errors┐main_query.png 53.25 kb
• 5/25/2022 3:25:07 PM Diagnostic.FormatDetailedLog imports\Diagnostic.FormatDetailedLog.pq 0.87 kb