Create a Custom Period Calendar in Power Query
Try this method when a normal calendar table will not "cut the mustard". One of the first concepts I heard of when I began my journey of using Power BI was creating and using a 'Date' table. A few short years ago, there wasn't nearly the amount of documentation as there is now; we are very fortunate. What you will find is there are numerous ways to accomplish this goal, and this is one way to solve a problem.
