Forum Discussion
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 Rai...
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
mlsx4 Thank you that worked 😊