The greatest challenge for many data professionals is access to robust and capable tools that allow them to do their jobs efficiently, effectively, and without delays. This page is dedicated to providing resources such as scripts, templates, and links to time-saving approaches for analytics. With time, I hope to provide a comprehensive toolkit that helps data professionals build solid foundations for their solutions.
Here is a post containing M Query scripts for Date and Time Dimensions. The scripts have been designed to work in Power BI DataFlows: https://insightsoutliers.com/2019/01/17/date-and-time-table-m-scripts-for-standard-tables-in-dataflows-for-power-bi/
Here’s an older version of the Date dimension table M query that is parameterized for Power BI Desktop Query Editor (or Excel Power Query): https://insightsoutliers.com/2018/04/19/m-script-date-dimension/