18.2 ISIN Date Functions in M Language in Power BI (Power Query) | Power BI Tutorial for Beginners скачать в хорошем качестве

18.2 ISIN Date Functions in M Language in Power BI (Power Query) | Power BI Tutorial for Beginners

#pavanlalwani #powerbi #businessintelligence #dataanalytics #powerquery In this video, you will learn how to use M functions in Power Query for date manipulation. We will focus specifically on date functions and explore approximately 25 M functions in this video alone. By the end of the three-part series, you will have a solid understanding of approximately 100 M functions for date manipulation. This video tutorial covers the topic of using the 'is in' function in M to determine if a date falls within the previous year. We will demonstrate how to check if a date is in the previous year, current year, or next year using this function. We will also discuss additional questions you can ask using this function, such as determining if a date falls within the previous n years or the next n years. If you find this video helpful, be sure to check out the next two videos in this series to further expand your knowledge of M functions for date manipulation. The link to the playlist containing all three videos is available in the description below. Note: This video tutorial is conducted using Power Query in Microsoft Power BI, but the concepts and functions covered can be applied to other M-powered tools as well. Watch more Power Query tutorials here:    • Power Query - Power BI   ---------------------------------------------------- 💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount: 🔗 https://rb.gy/l9ow5 📚 200+ MCQs to test your knowledge. 📝 20+ Assignments for hands-on practice. 🔍 11+ Case Studies for real-world insights. 💼 5+ Industry Projects to build your portfolio. 🎓 Course Completion Certificate for your resume. 💡 Tips & Tricks to boost your skills. 🔎 5+ Industry Datasets for practical learning. Join thousands of professionals who have transformed their careers. Enroll now at 50% off! 🎉🔗 https://rb.gy/l9ow5 You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX 🎉 🔗https://rb.gy/e5qhe Invest in yourself. Become a Power BI expert. The future is yours! 💼💪" 📥 Download Practice Material from Server 💾: Don't forget to use the hashtags #powerbi 📊 #datavisualization 📈 #datacleaning 👨‍💼 ---------------------------------------------------- Timestamps: 00:03 Introduction to working with m functions in power query for date 🌐 00:31 Overview of the different categories of functions in m function 📊 01:36 Importance of watching all three videos in continuation 🔀 02:06 Demonstrating the process of checking if a date is in previous, current, or next year ❓ 03:55 Generating an m function to check if a date is in the previous year 📅 05:07 Generating an m function to check if a date is in the next year ➡️ 06:00 Generating an m function to check if a date is in the previous three years 🔢 07:53 Exploring additional functions for previous and next quarters, months, weeks, and years 🔍 08:38 Practicing the different date functions for gaining a good command of m functions 📚 09:26 Preview of upcoming videos with more functions to cover a total of 100 m functions 💪