Skip to content

Instantly share code, notes, and snippets.

@Zidcov
Zidcov / CalendarGenerator.m
Created June 13, 2022 20:13 — forked from aaronsteers/CalendarGenerator.m
Power BI Calendar Function
# Step 1: Create a CalendarGenerator() function and paste the contents below into the Advanced Editor
let CreateDateTable = (StartDate as date, EndDate as date, optional Culture as nullable text) as table =>
let
DayCount = Duration.Days(Duration.From(EndDate - StartDate)),
Source = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),
TableFromList = Table.FromList(Source, Splitter.SplitByNothing()),
ChangedType = Table.TransformColumnTypes(TableFromList,{{"Column1", type date}}),
RenamedColumns = Table.RenameColumns(ChangedType,{{"Column1", "Date"}}),
InsertYear = Table.AddColumn(RenamedColumns, "Year", each Date.Year([Date])),
InsertQuarter = Table.AddColumn(InsertYear, "Quarter Number", each Date.QuarterOfYear([Date])),
Get-ChildItem -Path 'C:\Your\Directory\Here\' -Filter '*old*' | Rename-Item -NewName { $_.name -replace 'old','new' }