Thanks to Espen, there is a very nice article about that. I just wanted to leave a trace. Beware you…
If you try to create nice dashboards you will need this. https://www.mssqltips.com/sqlservertip/4054/creating-a-date-dimension-or-calendar-table-in-sql-server/