How to Calculate Difference Between Two Dates in Power Query

📧 Subscribe to my Email Newsletter - goodly.co.in/subscribe/
In this video, we'll learn how to calculate the difference between two dates in Power Query.
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course -
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step -
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards -
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@westcat77]

I love how straight to the point you are, no fillers just great info. Thanks!!

[@DaveyKennepohl]

Another great video!
Such an easy fix, for a common problem i run into so very often. Thanks!

[@aniketwanjari2624]

Hi Chandeep,
I follow ur video and its really learning.
With reference to above video. I am sharing a query ..
I have a colimns
1. containing ticket number
2. Ticket open time,e.g 12-12-2024 03:00:00
3. Ticket closed time,e.g 14-12-2024 03:00:00
I need a column with header :(time to resolve) this is nothing but difference between closed time and open time, answer should be in hours: minutes: seconds format only and not in any ither format
E.g. for above case it will be 48:00:00
Later i want to represent same in cards
I.e. sum of all tickets TTR
Average of all tickets TTR
And so on.
Please support.
This is something a limitation I found in power bi/query

[@dilipinamdarpatil6301]

Thank you 🙏

[@primamastergogo]

Hi , I have a question. When you load two Excel files into an editor, each file contains data for the past 12 weeks. However, when you refresh the files, the current week's data disappears and the data for the 13th week takes its place, causing the query to break. How can this issue be resolved?

[@dipanjankajuri3600]

Hi i have a date wherein it comes as a text with time like - 05/03/2024 - 09:03:01 . How to convert it into dd / mm /yyyy after removing the time portion

[@GoodlyChandeep]

Use Text.BeforeDelimiter and then Date.From

[@dipanjankajuri3600]

@@GoodlyChandeep ok will try and you know