Showing results for 
Search instead for 
Did you mean: 
Not applicable

Re: DATEDIFF incorrectly calculating

I apologize for the late response. I got pulled onto another project and haven't have the chance to check if there were duplicates that were aggregating until today. Once people see you can do cool things in Power BI, they want you to create a slew of reports and dashboards. 


So anyways, what I found was that when I was merging two queries on what I thought was a unique identifier. One of those queries had multiple lines for that "uniuqe identifier" and was indeed aggregrating the number rows and providing the multiplied number of days between the dates. Thank you for everyone's help on this and especially danextian in helping determine the root cause. Again, I apologize for the tardiness in my response.  The fix was to just make sure I had a true unique identifier when I merged the two queries and now everything is calculating as it should.



mwen90 Frequent Visitor
Frequent Visitor

Re: DATEDIFF incorrectly calculating



I am having this exact issue. How did you resolve it, I am a little confused as to the issue/resolution?


@Nolock this seems to the same issue?



Jadnerb Frequent Visitor
Frequent Visitor

Re: DATEDIFF incorrectly calculating

I would also like to know what the resolution is.

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 451 members 3,986 guests
Please welcome our newest community members: