Microsoft is planning to introduce a free version of its Power BI business-intelligence tools/service, and will cut prices on its new, fully featured Pro version.

On the other hand, if you’d like Power BI to do this for you, don’t mark the table as a date table. You can create the relationships and use it for specialized grouping and filtering instead.