12.2 How to find difference between dates in Power BI (Power Query) | Power BI Tutorial for Beginner
Вставка
- Опубліковано 5 вер 2024
- #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:
🔗 learn.pavanlal...
📚 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!
🎉🔗 learn.pavanlal...
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX
🎉 🔗learn.pavanlal...
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 ➡️
![How to Sum Hours, Minutes, and Seconds with DAX in Power BI [h:nn:ss]](http://i.ytimg.com/vi/Z1hGU93UE1c/mqdefault.jpg)
🚀 Calling all data enthusiasts! 💼🌟
👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!
🔗 Grab your discounted spot here: learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d
💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼
🔗 Explore the possibilities here: learn.pavanlalwani.com/courses/Power-BI-Dax-634fa813e4b0c08ed56c9919
SirG, Thanxxxx a lot.
Coz, I was badly searching for PQ formula to extract Earlier date and Later date from two dates.
2day, my pursuit is ended by watching your pin pointed explanation on this topic.
Hats of 2 U Sir.....
finished watching
Thank you 👍
Thank you😊😊😊😊😊😊
Well explained pavan sir...
I have a scenario..where I have 12 columns and I want to take sum of it...the way I am doing now is...I am selecting each column manually with + to add the columns in the insert custom function.
Is there any better way to do it more easily.
Your guidance will be very helpful...
I am your follower...I have learnt a lot of technical stuff from you sir...you are amazing.
Thanks and regards
Kishore
Sure.
Next section solution is there
With button clicks in seconds you will get the answer.
Wait for the video
Thank you
Thanks
Awesome sir. Can u please give a rough idea by how much days u will complete power bi?
Thanks
Total 110 videos are in Editing . Still.
Will finish probably by this month.
This video was very useful for me
Sir R programming ke tutorials banaye
Bilkul. Abi Power BI khatam karte hai
@@PavanLalwani G sir zaroor
@@PavanLalwani total kitne vedio hai..Embedded , Content pack par bhi video hoga kya
Hi Pavan Sir, Thanks for explaining the concept. If possible, could you please help me with below question, I could not find solution for this...
I need to calculate the time difference between the 2 date's.
e.g Formula Should be = End Date - Start Date
? = (End Date) 06/23/2023 10:49:00 pm - (Start Date) 09/28/2021 02:21: pm
I need to count how many hours are there between above days... I am getting answer 633.08.28 Hrs. by using subtract option in power bi, which is incorrect...
correct answer is 15200:28. I have calculated this in excel but unable to do so in Power bi.
Hope you understood my question and will help me with this...
Thanks in advance...
Use gpt to solve queries
Now it is not working on new version
it would be more useful if you can hide your face