Forum Discussion
New column if statement
Hi
I have used the simple if command as below
Late tasks = if(Tasks[TaskFinishDate] - RELATED(TaskBaselines[TaskBaselineFinishDate]) > 1 , 1 , 0)
does anyone know why is is not working correctly?
regards
It would be similar to
DATEDIFF(<start_date>, <end_date>, <interval>)The interval is the units so it would be one of these
- SECOND
- MINUTE
- HOUR
- DAY
- WEEK
- MONTH
- QUARTER
- YEARCheck it here https://docs.microsoft.com/en-us/dax/datediff-function-dax
5 Replies
You will need the Dax DATEDIFF function. I think you need to pass DAY as the third parameter.
I have just noticed that this question is in the Power Query forum but you wrote some DAX. That's OK but make sure you create the column in the right place.
It would be similar to
DATEDIFF(<start_date>, <end_date>, <interval>)The interval is the units so it would be one of these
- SECOND
- MINUTE
- HOUR
- DAY
- WEEK
- MONTH
- QUARTER
- YEARCheck it here https://docs.microsoft.com/en-us/dax/datediff-function-dax