Allocating Yearly Budgets to Months in Power Query M

This video shows how to split yearly budgets evenly over the months of the year and teaches useful list techniques for achieving this. I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:38 Creating a list of periods 01:17 Generating month names 05:06 Expand month names to rows 05:35 Setting a data type to list items 06:15 Turn amount into monthly value LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #budgetallocation #powerquery #m