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!

Share This:
Twitter
Facebook
LinkedIn

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

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.