Reply
NChamroo
Regular Visitor

Date Difference- Date column in 2 different columns

Hello guys, 

 

I am trying to calculate the number of days from 2 different tables and date columns. 

I am using DateDiff, but it is not picking up the tables. Appreciate your help. Thanks 

NChamroo_0-1720376696012.png

 

1 ACCEPTED SOLUTION
v-xuxinyi-msft
Community Support
Community Support

Hi @NChamroo 

 

Thanks for the reply from @foodd .

 

@NChamroo , I created a simple test for your reference.

 

My sample:

vxuxinyimsft_0-1720773792971.png

 

vxuxinyimsft_1-1720773805500.png

 

no relationship between two tables:

vxuxinyimsft_2-1720773862438.png

 

Create a measure as follows

Measure = DATEDIFF(MAX(Table1[StartTime]), MAX(Table2[EndTime]), DAY)

 

Output:

vxuxinyimsft_3-1720773915836.png

 

If this doesn't solve your problem, please provide some sample data and the expected results based on the sample data. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xuxinyi-msft
Community Support
Community Support

Hi @NChamroo 

 

Thanks for the reply from @foodd .

 

@NChamroo , I created a simple test for your reference.

 

My sample:

vxuxinyimsft_0-1720773792971.png

 

vxuxinyimsft_1-1720773805500.png

 

no relationship between two tables:

vxuxinyimsft_2-1720773862438.png

 

Create a measure as follows

Measure = DATEDIFF(MAX(Table1[StartTime]), MAX(Table2[EndTime]), DAY)

 

Output:

vxuxinyimsft_3-1720773915836.png

 

If this doesn't solve your problem, please provide some sample data and the expected results based on the sample data. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

foodd
Super User
Super User

Hello @NChamroo, and thank you for sharing a question with the Community.  Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)