Forum Discussion
Problem with IF and double pipe with three Conditions
I have written the following logic to provide 3 final categories:
IF (
[JobStatus] = "Cancelled",
"Cancelled",
IF (
[JobStatus]="Reject Work Order"
|| [JobStatus]="ADHOC REQUEST REJECT"
|| [JobStatus]="Rejected",
"Rejected",
"n/a"
))
However, it produces two "Rejected" categories, which are then not replicated in the Visual Filters pane, has anyone seen this before??
3 Replies
Hi Anonymous ,
By my tests with the latest version of Power bI desktop, I cannot reproduce your issue.
Firstly, please check if you have installed the latest version of Power BI Desktop 2.68.5432.841.
If you still need help, could you share the sample pbix which could reproduce your issue so that I could do a research on it?
Best Regards,
Cherry
Hi Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
