Just as having a date table can be extremely useful for various data models and DAX calculations, timetables can be equally useful. However, while DAX has various functions for easily creating date tables such as CALENDAR and CALENDARAUTO, no such equivalent exists for timetables. This recipe fixes that enables you to create timetables with ease!
Just open Power BI Desktop and you are all set.
To implement this recipe, do the following:
- Create a new table with the following formula: