Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Anonymous ,
I can get correct result. Could you please share more data?
Best Regards,
Winniz
@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?
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 |
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"
Hi @Anonymous ,
I can get correct result. Could you please share more data?
Best Regards,
Winniz
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |