Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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? 
 
 

Many Thanks 

Need Help
  • mlsx4's avatar
    mlsx4
    2 years ago

    Hi Anonymous 

     

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    mlsx4 Thank you that worked ğŸ˜Š

  • mlsx4's avatar
    mlsx4
    Memorable Member
    2 years ago

    Hi Anonymous 

     

    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