What problem does it solve? Building a complete date dimension for a Power BI semantic model is repetitive and error-prone: you need calendar, ISO week, fiscal, and to-date columns, correct sort keys, and a title measure that reflects the current date selection. This Skill injects a ready-made DimDate table and the 'Dates Selected' DAX measure directly into a PBIP project's TMDL files, with no Power BI Desktop or network access required. ## Core Features & Use Cases - Extended date dimension injection: Adds a 58-column DimDate table (calendar, ISO week, fiscal, to-date flags) generated by a bundled Power Query M function, with sort-by columns and format strings preset. - Dates Selected measure: Adds a DAX measure that renders the current slicer selection as a readable title such as 'Selected Period: Jan - Mar 2024'. - Configurable calendar parameters: Supports custom date ranges, dynamic end dates, fiscal year start month, week start convention, holiday lists, and mark-as-date-table settings. - Use Case: A BI developer starting a new PBIP project asks the agent to add a date table with a July fiscal year start; the script writes the TMDL files, updates model.tmdl references and query order, and the user only needs to add relationships and refresh in Power BI Desktop. ## Quick Start Ask the agent to add a date table to your PBIP semantic model, specifying the project path, date range, and fiscal year start month.
