David Onder dmonder
dmonder
/ BXL LAMBDA Excel Dates.txt
Created
January 10, 2025 19:55
— forked from CHatmaker/BXL 5g Functions LAMBDA for Excel Dates.txt
5g Functions for Excel: Dates
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Module Contains 5g Compliant LAMBDAs that deal with dates */ | |
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Mar 17 2023 Craig Hatmaker Original Development | |
| Mar 22 2023 Craig Hatmaker Added About | |
| Apr 06 2023 Craig Hatmaker Added Help to LAMBDAs | |
| Aug 28 2023 Craig Hatmaker Conformed to new template | |
| Jan 02 2024 Craig Hatmaker See CountDOWλ |
dmonder
/ BXL LAMBDA Dynamic Ranges
Created
January 10, 2025 19:53
— forked from CHatmaker/BXL 5g Functions LAMBDA for Excel Dynamic Ranges
5G functions for Excel for Dynamic Ranges
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Mar 02 2023 Craig Hatmaker Original Development | |
| Jun 08 2023 Craig Hatmaker CBSE Compliant | |
| Jan 17 2024 Craig Hatmaker See DynamicArrayλ | |
| */ | |
| Aboutλ =TEXTSPLIT( | |
| "About: →BXL's Dynamic Array module. Suggested module name: BDR¶" & |
dmonder
/ BXL LAMBDA Array Essentials
Created
January 10, 2025 19:52
— forked from CHatmaker/BXL 5g Functions LAMBDA for Excel Array Essentials
5G functions for basic Excel Dynamic Array handling
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Feb 27 2024 Craig Hatmaker Copyright | |
| Jun 05 2024 Craig Hatmaker Code Simplification | |
| Sep 05 2024 Craig Hatmaker Added RunTotColsλ and RunTotRowsλ | |
| */ | |
| Aboutλ = TRIM(TEXTSPLIT( | |
| "About: →Basic functions for working with dynamic arrays. Suggested module name: BXE¶" & |
dmonder
/ BXL LAMBDA Workbook Info
Created
January 10, 2025 19:49
— forked from CHatmaker/BXL 5g Functions LAMBDA Workbook Info
5G functions for Excel Workbook Information
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Dec 14 2023 Craig Hatmaker Original Development | |
| */ | |
| Aboutλ = TRIM(TEXTSPLIT( | |
| "About: →BXL's Workbook Information module. Suggested module name: BXW¶" & | |
| "Version: →Jun 12 2023¶" & | |
| "Gist URL: →https://gist.github.com/CHatmaker/3ff1b5ce97344c2dfc3f1623a656676a ¶" & |
dmonder
/ UNPIVOT.lambda
Created
January 10, 2025 04:35
— forked from ExcelRobot/UNPIVOT.lambda
Unpivot Table LAMBDA Function
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Name: Unpivot Table (UNPIVOT) | |
| Description: Given a table range with headers and array of header names, unpivots the | |
| specified columns in place, optionally removing any blank entries. | |
| Written By: Excel Robot (@ExcelRobot) | |
| Category: Array | |
| */ | |
| UNPIVOT=LAMBDA(table,[columns_to_unpivot],[attribute_name],[value_name],[remove_blanks], LET( | |
| _ColumnsToUnpivot, IF( | |
| ISOMITTED(columns_to_unpivot), |
dmonder
/ BXL LAMBDA Reporting with Arrays
Created
January 10, 2025 04:30
— forked from CHatmaker/BXL LAMBDA Reporting with Arrays
5G functions for Excel for Reporting with Arrays
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* FUNCTION NAME: Aboutλ | |
| DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/ | |
| /* REVISIONS: Date Developer Description | |
| Mar 17 2023 Craig Hatmaker Copyright | |
| Apr 17 2023 Craig Hatmaker Reorganizing and adding help | |
| Jul 03 2023 Craig Hatmaker See nFoldCartProdλ and PriorDimProdλ | |
| Jul 11 2023 Craig Hatmaker See UnPivotDetailλ | |
| Feb 11 2024 Craig Hatmaker See UnPivotDetailλ | |
| */ |
dmonder
/ List.SelectPositions.pq
Created
January 3, 2020 17:17
— forked from ImkeF/List.SelectPositions.pq
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| let func = | |
| (SelectionList as list, ListOfPositions as list, optional StartWithOne as number, optional FillWithNulls as number) => | |
| let | |
| selectionList = List.Buffer(SelectionList), | |
| listOfPositions = ListOfPositions, | |
| StartPosition = if StartWithOne = 1 then -1 else 0, | |
| Result = {List.Transform(listOfPositions, each selectionList{_ + StartPosition}), // null | |
| List.Transform(listOfPositions, each selectionList{_+StartPosition}?), // 0 |