Forum Discussion
Solved
DATEDIFF
Hi
I want to calculate the difference between two dates in DATE/TIME format and return the difference in MINUTES.
the DAX formula as follows:
DateDiff = DATEDIFF(TABLE[Start Date],TABLE[Ended On].[Date],MINUTE)
my question is why are there zero values?The difference in minutes in the first row should be 570 minutes instead it is showing zero?
Both dates format are DATE/TIME format from Power Query Editor.
thank you for your help
Please Write below Formula
DateDiff = DATEDIFF(TABLE[Start Date],TABLE[Ended On],MINUTE)
Note - Remove .Date from [Ended On]
Please Accept a Solution if you solved it.
1 Reply
Please Write below Formula
DateDiff = DATEDIFF(TABLE[Start Date],TABLE[Ended On],MINUTE)
Note - Remove .Date from [Ended On]
Please Accept a Solution if you solved it.