Matthew Roche gives us a date dimension:
A bunch of folks from the Power BI community shared their favorite Power Query date dimension queries – you can look at the Twitter thread for links if you’re interested. With their inspiration (and code!) I picked what I liked, discarded what I didn’t, and came up with this:
Click through for that code.