Turning 445 Summary Tables into Usable Calendar Tables in Power BI

Stay up to date with the latest customer data news, expert guidance, and resources.

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!

Share This:
Twitter
Facebook
LinkedIn

More Resources

Your Data, Analytics & AI Partner

Industry leaders choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, Skypoint Cloud turns siloed data into connected experiences.