Lars Schreiber SchreiberLars

## fnGetDeutscheFeiertageJeBundesland
let func = (Kalenderjahr as number) as table =>
   let
     //Liste aller Bundeländer für den Aufbau der URL bei arbeitstage.org
     List_Bundeslaender = {
         "baden-wuerttemberg",
         "bayern", "berlin",
         "brandenburg",
         "bremen",
         "hamburg",
         "hessen",

## fnReturnCustError.pq
(IDCustErr as number)=>
let
   //IDCustErr = 5, /* for debugging purposes */

  //  ============ START: Define your list of custom error records here ====================
  ListCustomErrors = {
        //Custom error #1: The only permissible tax rates are as follows 7% and 19%
        [
            CustErrID = 1,
            reason ="Illegal tax rate",

## fnUTC2Local.pq
(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

## fnRelativerSpaltenvergleich.pq
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
        */
        /*

## fnGeschaeftsHalbjahr.pq
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),

## fnGeschaeftsHalbjahrUndJahr.pq
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),

## fnGeschaeftsQuartalUndJahr.pq
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),

## fnGeschaeftsQuartal.pq
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),

## fnGeschaeftsMonatUndJahr.pq
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),

## fnGeschaeftsmonat.pq
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),