Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 correctl...
Need Help
HotChilli's avatar
HotChilli
Community Champion
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    HotChilli
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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 ?