It would be nice to have a tool for automatically generating a date table - there are lots of sample SQL code and M code out there for doing so, but it would still be nice to have a built-in facility...
rozack
Advocate I
Advocate II think this a very good suggestion and can be done quickly as well. Currently we create the DimDate in SQL server and then import the same here. Similar tool is also available in Excel as an Add-on. In PowerBI tool should be able to do the following: 1. Select the Date Range or Auto Generate based on some Date field 2. Allow the user to define Financial Year, 3. Add Granular Columns such are Day of Week, Day of the year, Month Name, etc... ( some functions already there in Edit Query > Date & Time 4. Define Start of the Week & Define Weekends 5. Attach a Holiday Calendar 6. Add Time Buckets 7. Add AM / PM or 24 Hour Periods Once all these functions are developed the user can click on Generate the table & the system can detect relations in a popup menu and select/de-select and save.
