DATEDIFF not showing correctly

[NightingaleG3]

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? 

Many Thanks 

[NightingaleG3]

@mlsx4 Thank you that worked 😊

[mlsx4 · Accepted solution]

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