The following sample from a date dimension SQL view includes several columns that will be needed by the Power BI dataset:
The Calendar Year Month Number column can be used to define the default sort order of the Calendar Yr-Mo column and can also support date intelligence DAX measure expressions that select a specific time, frame such as the trailing four months. Likewise, a prior calendar year date (or prior fiscal year date) column can be referenced in date intelligence measure expressions. The Calendar Month Status and Calendar Year Status columns make it easy for report authors to define ...