How to Calculate the TIME Between Two Dates with the DATEDIFF DAX function in Power BI

In this tutorial, I'll teach you how to calculate the time between two dates with the DATEDIFF Dax function in Power BI
Navigate through the content below:
0:26 Agenda
0:50 DATEDIFF
1:32 Practical Case
Content Link: drive.google.com/file/d/13HP0...
___Merchandise [T-Shirts, stickers, mugs, hats, etc.]
Store: / @nestoradrianzen
___Highly recommended Power BI books (Affiliate links):
***Expert Data Modeling with Power BI by Soheil Bakhshi
Hard Cover Book: amzn.to/3DyVwrc
E-Book: amzn.to/3mMQ0uf
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: amzn.to/3ldPLpk
***DAX Patterns (Second Edition): amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: amzn.to/3fDPLOd
***Beginning DAX with Power BI: amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: amzn.to/36c6Cot
***Information Dashboard Design: amzn.to/2V61o7h
___________Relevant PBI Topics
- MEASURES vs CALCULATED COLUMNS in DAX: • MEASURES vs CALCULATED...
- How to Use the ALL DAX Function in Power BI: • How to Use the ALL DAX...
- How to Use the Filter DAX Function in Power BI [The Basics]: • How to Use the Filter ...
- How to Calculate PERCENTAGES in Power BI: • How to Calculate PERCE...
- How to COMBINE Tables in Power BI: • How to COMBINE Tables ...
____________
[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.
If you like the content, feel free to buy me a cup of coffee 😀👇paypal.me/vizxlizationUS
If you don't want to miss anything, subscribe to our newsletter: www.vizxlization.com/subscrib...
___________Let's Connect:
Web: www.vizxlization.com/
LinkedIn: / vizxlization
Twitter: / vizxlization
Facebook: / vizxlization
Instagram: / nestoradrianzen
Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!
#PowerBI #vizxlization #PowerQuery

[@NestorAdrianzen]

Have you used the DATEDIFF function before? Leave your comments below. Also, here is the content. Enjoy! 0:26 Agenda 0:50 DATEDIFF 1:32 Practical Case

[@bendreessen2809]

Thank you Nestor, this was easy to follow along as you explained each step.

[@NestorAdrianzen]

Glad to hear that. Cheers!

[@IvanCortinas_ES]

Thank you Nestor. The video is as brilliant as ever. Super explanation!!!

[@NestorAdrianzen]

Thanks for your support, Iván! Cheers!

[@hazrahadee6257]

Thank you, Nestor! Appreciate it much!

[@NestorAdrianzen]

Thanks for your support, Hazra! Keep up the great work 👍

[@hazrahadee6257]

Hi Nestor, really appreciate you making a video of my question. You have a great way of explaining it in simple terms. I have another question, which I thought would have been easy to solve, but I have my head against the wall! I have a column with the average time worked by an agent. I am trying to get a total/sum of this average! Did not think it would be hard or I am plain stupid! Appreciate it if you could provide some pearls of wisdom! Thanks a ton in advance

[@NestorAdrianzen]

Hasra, Thanks for your feedback. For these types of calculations, you might want to use measures. This tutorial might help. kzbin.info/www/bejne/b3rHd6RolrWro7s

[@hazrahadee6257]

@@NestorAdrianzen Thank you, let me check it out.

[@taraprasaddash8643]

Love your videos as always.

[@NestorAdrianzen]

Tara, Thanks for stopping by.

[@rainbow433]

good explanation

[@NestorAdrianzen]

Thanks for your support!

[@sravankumar1767]

Nice explanation Nestor 👌 👍 👏

[@NestorAdrianzen]

Awesome! Thanks for your support, Sravan!

[@shalinigoalla5644]

Hi Nestor, I used datediff for one of my requirements, where I have to show hrs difference But I have to show like 1:30, 1:16 mins like this instead of showing like 1 hr, 2 hrs help me with this pls

[@kbg001]

Hi Sir, is it possible to replicate same excel formula in powerBI, since i am not meeting exact results in powerBI "=DATEDIF(C5,D5,"y") & " Years " &DATEDIF(C5,D5,"ym") & " Months ", When i use same formula in PowerBI i am not getting profer results and even unable to figure it out in powerBI dax, please help me

[@souzaeq]

Nice video; really helped. I still have one doubt: I need to divide the value to split among the days, wich time dax or transformation in power query should I use like to divide the total revenue by the number of days and then create a line for each recurrence. Like: USD 100/ 4 days, is USD 25/ day, how can I automatically generate starting from current information as 4/jan/2023 (end date) with 100 USD to 1/jan/2023 with USD 25, 2/jan/2023 with USD 25, 3/jan/2023 with USD 25 and 4/jan/2023 with USD 25 ?

[@jorgedavalos5533]

What if I want to calculate the difference not of to columns but form each row?

[@NestorAdrianzen]

Jorge, Thanks for stopping by. Do you mean the different between the rows from two different columns within the same table? If so, you can still use the DATEDIFF function. You can create a calculated column. I hope that helps! Here is the syntax for reference: DATEDIFF(, , )

[@jovybatican1124]

@@NestorAdrianzen hi how about if I want to get the difference of days in the same column?

[@taraprasaddash8643]

Nester, Could you please make a video to change all the calculation in a dashboard from month to date to year to date by the help of a filter in the dashboard.

[@NestorAdrianzen]

I'll add this to my list. I think you are talking about dynamic Power BI reports.

[@taraprasaddash8643]

Yes