Lars Schreiber SchreiberLars
SchreiberLars
/ fnGeschaeftsQuartal.pq
Last active
June 28, 2018 14:55
This file contains 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 | |
| fn = (MyDate as date, StartMonat as text) => | |
| let | |
| Startmonatsnummer = | |
| List.PositionOf( | |
| {"januar", "februar","märz","april","mai","juni", "juli", "august", "september", "oktober", "november", "dezember"}, | |
| Text.Lower(StartMonat) | |
| ) + 1, | |
| Offset = Startmonatsnummer -1, | |
| AtuellerKalendermonat = Date.Month(MyDate), |
SchreiberLars
/ fnGeschaeftsQuartalUndJahr.pq
Last active
June 28, 2018 14:58
This file contains 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 | |
| fn = (MyDate as date, StartMonat as text) => | |
| let | |
| Startmonatsnummer = | |
| List.PositionOf( | |
| {"januar", "februar","märz","april","mai","juni", "juli", "august", "september", "oktober", "november", "dezember"}, | |
| Text.Lower(StartMonat) | |
| ) + 1, | |
| Offset = Startmonatsnummer -1, | |
| AtuellerKalendermonat = Date.Month(MyDate), |
SchreiberLars
/ fnGeschaeftsHalbjahrUndJahr.pq
Created
June 28, 2018 15:00
This file contains 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 | |
| fn = (MyDate as date, StartMonat as text) => | |
| let | |
| Startmonatsnummer = | |
| List.PositionOf( | |
| {"januar", "februar","märz","april","mai","juni", "juli", "august", "september", "oktober", "november", "dezember"}, | |
| Text.Lower(StartMonat) | |
| ) + 1, | |
| Offset = Startmonatsnummer -1, | |
| AtuellerKalendermonat = Date.Month(MyDate), |
SchreiberLars
/ fnGeschaeftsHalbjahr.pq
Created
June 28, 2018 15:02
This file contains 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 | |
| fn = (MyDate as date, StartMonat as text) => | |
| let | |
| Startmonatsnummer = | |
| List.PositionOf( | |
| {"januar", "februar","märz","april","mai","juni", "juli", "august", "september", "oktober", "november", "dezember"}, | |
| Text.Lower(StartMonat) | |
| ) + 1, | |
| Offset = Startmonatsnummer -1, | |
| AtuellerKalendermonat = Date.Month(MyDate), |
SchreiberLars
/ fnRelativerSpaltenvergleich.pq
Last active
July 13, 2019 16:55
This file contains 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 | |
| /* | |
| Beginn der Funktionsdefinition, mit Funktionsnamen, Funktionsparametern und Typ des Funktionsrückgabewertes | |
| */ | |
| fnInsertDiffColumn = (ColumnName as text, MyTable as table) as table => | |
| let | |
| /* | |
| Parameter für das Testen der Funktion, während der Entwicklungsphase | |
| */ | |
| /* |
SchreiberLars
/ fnUTC2Local.pq
Last active
October 28, 2019 13:01
This file contains 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
| (DateTimeUTC as datetime) as datetime => | |
| let | |
| /* | |
| ================================================================================ | |
| Wesentliche Bestandteile der Funktion basieren auf der Arbeit von 'Frank Tonsen' | |
| ================================================================================ | |
| */ | |
| Year = Date.Year(DateTimeUTC), | |
| //Ermittlung der Grenze der Winterzeit --> letzter Sonntags im März, 00:59:59 Uhr UTC |
SchreiberLars
/ fnImportCSVsWithDifferentStructure.pq
Last active
February 17, 2020 16:26
This file contains 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 = (PfadZumOrdner as text, Spaltentrennzeichen as text, EncodingCode as number ) as table => | |
| let | |
| //Hier den Funktions-Corpus eintragen | |
| //=========================================Beispielparameter fürs Debugging==================================== | |
| /*PfadZumOrdner = "H:\SSBI-Blog\Website\Business Topics\_csvs mit verschiedenen Headern einlesen\Datenquelle", | |
| Spaltentrennzeichen = ";", | |
| EncodingCode = 1252 | |
| */ | |
| //=========================================Beispielparameter fürs Debugging==================================== */ |
SchreiberLars
/ #2 sum over columns - Bill Szysz.pq
Last active
June 6, 2020 07:53
This file contains 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 | |
| /* | |
| Creating a list of monthnames... format and language of the list can | |
| easily be changed by the last two parameters | |
| */ | |
| MonthsList = List.Transform({0..11}, each Date.ToText(#date(1900,1,1) + | |
| Duration.From(_*31), "MMMM", "en-GB")), | |
| Source = Excel.CurrentWorkbook(){[Name="Datenbasis"]}[Content], |
SchreiberLars
/ #1 sum over columns - Bill Szysz.pq
Last active
June 6, 2020 07:57
This file contains 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 | |
| /* | |
| Creating a list of monthnames... | |
| format and language of the list can easily by changes by the last two parameters | |
| */ | |
| MonthsList = List.Transform( | |
| {0..11}, | |
| each Date.ToText(#date(1900, 1, 1) + Duration.From(_ * 31), "MMMM", "en-Us") | |
| ), | |
| Source = Excel.CurrentWorkbook(){[Name = "Datenbasis"]}[Content], |
SchreiberLars
/ #3 sum over columns - Imke Feldmann.pq
Last active
June 6, 2020 08:01
This file contains 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 | |
| /* | |
| This is Bill's version of getting a list of months... | |
| as this is not a critical part for the over all solution, | |
| I just copied it into this solution as well | |
| */ | |
| List_AllMonths = List.Transform({0..11}, each Date.ToText(#date(1900, 1, 1) + | |
| Duration.From(_ * 31), "MMMM", "en-Us")), | |
| Source = Excel.CurrentWorkbook(){[Name="Datenbasis"]}[Content], |