Turning 445 Summary Tables into Usable Calendar Tables in Power BI

If you’re used to working in Excel you’re quite familiar with the idea that there’s about a dozen ways to do anything. In this video we look at yet another approach to creating a 4-4-5 fiscal calendar table from a summary table. Our associate Jen Memhard posted a fantastic and quite thorough tutorial on the subject here back in November; and the idea with this video is to give you a sense of how many different ways there are to solve the same problem in the M language and also introduce you to one of my favorite functions, “List.Dates()”.

Happy Reporting!

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?