Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Coelijoeli
New Member

Calculate date difference

Hello Community,

 

I am looking for a way to find the difference between two dates.

 

I tried te following example: Date1 - Date2

This does not give me the difference... this gives me a weird date value.

 

I tried to use DATEDIFF, but it does not work because Date 2 can have a lower date then date 1.

 

What are other options I can use?

1 ACCEPTED SOLUTION

@Coelijoeli

There was just a recent thread on this. Depending on what you need to do there are several solutions.

 

Thread

 

My quick solution:

diff = 1.0*([Closed]-[TransactionDate])

 

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

3 REPLIES 3
SamsonAnalytics
Frequent Visitor

Use this code in a new column:

_DateDiferrence =
VAR
Sum_Date=Calculate(sumx('TableName','TableName'[DATE1]-'TableName'[DATE2]))
RETURN
if(sum_Date>=0,Sum_Date,0)
 
I hope it works for you
Anonymous
Not applicable

hi @SamsonAnalytics 

how would this look if you want to calculate the average for eg products?


and how would this look if the dates are on two different columns?

thank you in advance,

Niki

@Coelijoeli

There was just a recent thread on this. Depending on what you need to do there are several solutions.

 

Thread

 

My quick solution:

diff = 1.0*([Closed]-[TransactionDate])

 

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.