Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Good day.
Asking for your help, I am only a beginner.
I am struggling to get the Status in Table 2 that excludes Process #1,
by using New column?
These are my 2 sample tables:
And my sample Desired Output:
Reference for my Status Column:
On-Going if the Group still have "Not Yet Done" Remarks, ignoring Process 1.
Completed If the Group have "Ignore/Done" Remarks, ignoring Process 1.
Thank you in advance :)
Solved! Go to Solution.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank You so much Sir..
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |