top of page

BLOGS


Power Query: Reusable Calendar function
This Power Query function dynamically generates a calendar table based on a given start date, end date, and fiscal year start month . It is designed to support time-based analysis in Power BI by including key date attributes, fiscal calculations, and various helper columns. Power Query Calendar Function diagram illustrating parameter inputs for start date, end date, and fiscal start month, with outputs like date, fiscal year, ISO week, and day classifications such as weeke

MirVel
Mar 32 min read
bottom of page




