Power Query Date Table That Works Like CALENDARAUTO — Fully Automated Using Fact Table Dates
Most Power BI developers know about CALENDARAUTO() in DAX. It automatically scans the entire model and generates a date table based on the minimum and maximum date values.