18.3 Add and Subtract Date M Functions in Power BI (Power Query) | Power BI Tutorial for Beginners
#pavanlalwani #powerquery #excel #dataanalytics
In this video, we will learn how to work with various M functions in Power BI to add and subtract days from a given date. We will start by loading the necessary data and duplicating the table. Next, we will demonstrate the step-by-step process of adding and subtracting days. For adding, we will use the "date add" function and select the desired time interval (months, quarters, or weeks) to be added. Similarly, for subtraction, we will use the same "date add" function but specify a negative value for the desired time interval. These M functions make the process incredibly simple and efficient, even for beginners in Power BI. Watch this video to enhance your Power BI skills and improve your date manipulation capabilities!
---------------------------------------------------------
💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount:
🔗 https://learn.pavanlalwani.com/course...
📚 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://learn.pavanlalwani.com/s/store
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX
🎉 🔗https://learn.pavanlalwani.com/course...
Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"
📥 Download Practice Material from Server 💾:
#datacleaning #businessintelligence #powerbi #excelfunctions
---------------------------------------------------------
Timestamps:
00:00:03 Adding and Subtracting Days using M functions 📅➕➖
00:00:30 Duplicating and Preparing the Data ✨
00:00:59 Adding Five Months to Dates 🗓️⏩
00:01:27 Adding Five Years to Dates 📆⏩
00:02:21 Subtracting Five Months from Dates 🗓️⏪
00:02:49 Subtracting Five Years from Dates 📆⏪
