Unable to compare the dates in power bi it is giving me the wrong value

[Anonymous]

if ([TestingPhase] = "Interim – Common Process" and [Interim_Status] = "Level 1 Review" and [Level1ReviewDate] > [Level1ReviewDueDate] ) then "Delayed" else "On Track"

In the above code I'm getting just the "On Track" in every cells.

[amitchandak]

@Anonymous , the formula seems fine. Can share some same with correct and wrong output to check

Can you share sample data and sample output in table format?

[Anonymous]

TestingPhase	Level1ReviewDate	Interim_Status	Level1ReviewDueDate	Custom
Interim – Common Process	10/07/2021	Level 1 Review	08/07/2021	On Track
Interim – Common Process	10/07/2021	Level 1 Review	08/07/2021	On Track
Walkthrough		Level 4 Review	08/07/2021	null

[Anonymous]

So basically it is working with single IF and else statement but in my query there are multiple if and else if statements in that case it is not working

Query is like this

if ([TestingPhase] = "Walkthrough" and [WalkthroughStatus] = "Completed" and [Level4ReviewDate] > [CompletionDueDate] ) then "Delayed"

else if ([TestingPhase] = "Interim – Common Process" and [Interim_Status] = "Not Started" and [Actual Start Date] > [Expected Start Date] ) then "Delayed"

else "On Track"

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

I can get correct result. Could you please share more data?

Best Regards,
Winniz

[Anonymous]

I'm not sure on why it's not working although when I wrote the same piece of code in DAX editor instead of Query editor I got it working

[v-kkf-msft]

Hi @Anonymous ,

If the problem is solved, please mark your reply that will help the other members find it more quickly.

If you still have doubts, please provide detailed error information. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz