Pinned Loading

1. [Basic Calendar Table] #powerquery [Basic Calendar Table] #powerquery

   1

   let

   2

       Kalendertabelle = (startDate as date, endDate as date, optional Culture as nullable text) =>

   3

           let 

   4

               days = Duration.Days(endDate - startDate) + 1,

   5

               date_range = List.Dates(startDate, days, #duration(1, 0, 0, 0) ),

2. [Loads HubSpot CRM v3 objects] #powe... [Loads HubSpot CRM v3 objects] #powerquery

   1

   let

   2

     // Main function: fetch CRM objects with optional property history and associations

   3

     Fn = (object as text, props as list, optional propsHistory as nullable list, optional assoc as nullable list) as table =>

   4

     let

   5

       useHistory = propsHistory <> null and List.Count(propsHistory) > 0,