New column if statement

[Anonymous]

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 

[HotChilli]

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.

[Anonymous]

thanks 

I am very new in Power bi, 

could you please tell me an example? 

I couldn't understnd what the third argumnet is

thanks 

[HotChilli · Accepted solution]

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
- YEAR

Check it here https://docs.microsoft.com/en-us/dax/datediff-function-dax 

[Anonymous]

I still have issue with the below formula

Late tasks = IF((DATEDIFF(Tasks[TaskActualFinishDate],RELATED(TaskBaselines[TaskBaselineFinishDate]),DAY))<0,"Late"," ")

is that wrong as I am getting wrong result 

can you help please ?

[Anonymous]

Thanks