Quartalswerte GANZZAHLIG auf Monate verteilen | Power Query

Distributing quarterly values ​​as integers across months is possible with Power Query, although not entirely straightforward. In this video, I answer Benedikt's question about how to implement this in Power Query. Have fun! 😉 📊 SAMPLE FILES 📊 The sample files used are available free of charge to my newsletter subscribers: http://eepurl.com/cmkOEz 🎓 VIDEO COURSE 🎓 My comprehensive Power Query beginner's course with 160+ videos – everything you need to know about data import and automation: https://myablefy.com/s/ssbi-blog/powe... 👨‍🎓 TRAINING 👩‍🎓 My Power BI online training courses: https://ssbi-blog.de/power-bi-schulungen 🥷 CONSULTING 🥷 Want to book a consultation? Here's the link: https://calendly.com/ssbi-blog/15min 📹 CONTENTS 📹 00:00 Preface 00:26 Intro 00:35 Hello + Topic 01:08 Sample Data 03:30 Preparing the Base Values 04:32 Determining the Starting Month 05:24 Determining the Divisor 05:58 Calculating the Distributed Monthly Values 08:15 List: First Month + Value 12:37 List: Months 2 & 3 23:43 Creating the Final List 25:40 Checking with Additional Values 26:11 Closing Remarks 🙋‍♂️ CONTACT 🙋‍♂️ Website: https://ssbi-blog.de/ LinkedIn:   / lars-schreiber-power-bi   🤿 SETUP 🤿 https://kit.co/LarsSchreiber/office-s...