How to Calculate Difference Between Two Dates in Power Query

In this video, we'll learn how to calculate the difference between two dates in Power Query.

===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -

✔️ Mastering DAX in Power BI -

✔️ Power Query Course -

✔️ Master Excel Step by Step -

✔️ Business Intelligence Dashboards -

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== 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!

[westcat]

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

[aniketwanjari]

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

[Baveitje]

Another great video!

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

[dipanjankajuri]

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

[ezelkarlkl]

Thank you for sharing.. How can we count of mondays, tuesdays etc... between 2 dates with your example data.? Thank you again.

[PollyBondaruk]

Hi, thank you so much for your super helpful videos,
I was wondering if you had experience calculating difference between dates that are in the table in direct query mode in Power bi? I have the following columns:
- created on date column
- closed date column (contains empty cells as not all deals happen to close as won)

Thank you in advance.

[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?

[VijayKumar-zdou]

Hi Chandeep,

Can you assist me with how to fetch historical data for NSE stocks from the Equity Pandit website using Power Query, with date references from cells? We need a video demonstrating this process for educational purposes. Please help us understand how to fetch historical data for multiple NSE stocks with date cell references using Power Query from the Equity Pandit website🙏🙏🙏

[SDrent-ehct]

How to get the differnce in days between End and Start( on the next row)

[Wzxxx]

I can't use this subtract days? It is always grayed out. Do You have any idea why it is like that? Is it bugged? I 100% check 2 columns in order.