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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
NightingaleG3
New Member

DATEDIFF not showing correctly

Hello, 

 

Very new to Power BI 😃

 

I've found the following way to show sum of days between in a table. I've added a colunm with the following: 

Days between = DATEDIFF('Table_query'[Month Raised (Date)].[Day],'Table_query'[Month Assigned To WD Team Member (Date)].[Day],DAY)
 
Seems to work except on 1 highlighted below, showing as -7. When is should be 24. Can anyone advise on what's gone wrong? 
 
 
NightingaleG3_0-1706803694469.png

Many Thanks 

1 ACCEPTED SOLUTION
mlsx4
Memorable Member
Memorable Member

Hi @NightingaleG3 

 

You're calculating difference between days (without taking into account anything else: month or year). Therefore: 8-15=-7

 

Try by removing the .[day] in your formula

View solution in original post

2 REPLIES 2
NightingaleG3
New Member

@mlsx4 Thank you that worked 😊

mlsx4
Memorable Member
Memorable Member

Hi @NightingaleG3 

 

You're calculating difference between days (without taking into account anything else: month or year). Therefore: 8-15=-7

 

Try by removing the .[day] in your formula

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!