12.2 How to find difference between dates in Power BI (Power Query) | Power BI Tutorial for Beginner скачать в хорошем качестве

12.2 How to find difference between dates in Power BI (Power Query) | Power BI Tutorial for Beginner

#pavanlalwani #powerquery #datefunctions #dataanalytics In this video, we will learn how to calculate the difference between two dates and identify the earliest and latest dates. We have already imported the necessary data in the previous video, and I will demonstrate how to use Power Query Editor to perform these calculations. The table we will be working with is named "date two," consisting of two columns: date one and date two. We will analyze a few sample dates, such as 21st of February 2020 and 12th of February 2020. The first column represents the larger date, while the second column represents the smaller date. However, if we consider another example, with dates 10th of March and 30th of March, the smaller and larger dates are reversed. To find the difference between the two columns, simply select the first column, hold the Ctrl key, and click on the second column. Then, navigate to the "Add Column" tab and choose the "Subtract Days" option. This will give you the difference between the two dates without requiring you to write any code. Next, to determine the earliest date between the two columns, select both columns and select the "Earliest" option from the date menu. If this option is not available, ensure that the data type of your columns is set to date. The earliest date will be displayed in the results. For the latest date, follow the same process but choose the "Latest" option instead. This provides a quick and efficient method to obtain the desired information, eliminating the need for complex functions in Excel or other programming languages. I hope this video has helped you understand how to find the difference between dates and identify the earliest and latest dates. If you have any questions, feel free to ask in the comments section. --------------------------------------------------------- 💼 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 💾: #powerquery #businessintelligence #powerbi #excelfunctions --------------------------------------------------------- Timestamps: 00:00:03 Finding Difference between Dates ➖ 00:00:27 Comparing Date Values ⚖️ 00:00:55 Calculating the Date Difference ➖ 00:01:19 Finding the Earliest Date ☑️ 00:01:41 Displaying the Earliest Date ⬅️ 00:02:09 Finding the Latest Date ➡️