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...
rsbin Can you please help me here? there is a slight change in the last condition
1. ID-wise, all cow then cow
2. ID-wise, all Revisit then Revisit
3 else COW
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