How to Calculate Difference Between Two Dates in Power Query

[@westcat77]

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

[@ezelkarlkl1284]

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

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

[@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.

[@VijayKumar-zd7ou]

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🙏🙏🙏

[@DaveyKennepohl]

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

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

[@dilipinamdarpatil6301]

Thank you 🙏

[@SDrent-eh4ct]

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

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