Forum Discussion
Solved
Need help in calculation
Hi everyone, I m trying to calculate the Final Output column 1. If the same ID has multiple only COW values, print COW 2. If the same ID has multiple only Revisit values, print Revisit 3. I...
I don't see any changes in your conditions. These 3 conditions are exactly the same as in your original post.
What do you want changed?
Thank you rsbin
1. ID-wise, all cow then cow
2. ID-wise, all Revisit then Revisit
3 else COW
So change in 3rd condition. Can you please try the same you attached .pbix in the solution post.
| ID | Values | Final Output |
| S000947-A-003 | COW | COW |
| S000947-A-003 | Revisit | COW |
| S000960-A-003 | COW | COW |
| S000960-A-003 | COW | COW |
| S000982-A-003 | Revisit | Revisit |
| S000982-A-003 | Revisit | Revisit |
| S001901-A-001 | Revisit | COW |
| S001901-A-001 | COW | COW |