wynhopkins
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
| /*Courtesy of Access Analytic | |
| Website: https://accessanalytic.com.au/ | |
| YouTube: https://www.youtube.com/@accessanalytic | |
| Gist: https://gist.github.com/wynhopkins/2efdf218ed78be03a0a082ff6a99dad1 | |
| ------------------------------------------------------------------ | |
| ------------------------------------------------------------------ | |
| */ | |
| /*----------------------------------------------- |
wynhopkins
/ Power Query Calendar
Created
February 10, 2022 12:13
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 | |
| //courtesy of AccessAnalytic.com.au | |
| Today = Date.From(DateTime.LocalNow() ), | |
| // Change start date to begining of year | |
| StartDate= #date(2019, 1, 1), | |
| //see advanced editor for note on alternative hardcoding EndDate method |
wynhopkins
/ gist:02e4d1951e65334db53ce17f5519190f
Last active
October 21, 2023 08:24
Wyn Trial Lambdas
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
| //ListOfTextMatches------------------ | |
| // Select a word to look for and a column to look in | |
| //outputs filtered list containing that text | |
| ListOfTextMatches= | |
| LAMBDA( | |
| SelectTextToLookFor, | |
| SelectRangeToLookIn, | |
| LET( | |
| FlagMatch, | |
| ISNUMBER( |