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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Shackwell
Helper III
Helper III

Need help with date diff

Hello,

 

I´ve been trying to use date difference between two columns in a database and Im unable to link them in the measure formula. Whenever I try to input ' the only options available are my other set of measures.

 

Basically what I´m looking to do is to calculate the delay between scheduled date and shipment date.

 

Thank you for your time.

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hi @Shackwell ,

 

Try something like this:

Days Difference = SUMX('yourTable', DATEDIFF('yourTable'[ScheduleDate], 'yourTable'[ShipmentDate], DAY))

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

1 REPLY 1
Pragati11
Super User
Super User

Hi @Shackwell ,

 

Try something like this:

Days Difference = SUMX('yourTable', DATEDIFF('yourTable'[ScheduleDate], 'yourTable'[ShipmentDate], DAY))

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors