March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Input data.here i want to add a column where if status is pass then all the checkpoint before
ID | AT checkpoint | status | Checkpoint |
A | 1 | 1 | |
A | 1 | 2 | |
A | 3 | 1 | |
A | 3 | 2 | |
A | 5 | Pass | 1 |
A | 5 | Pass | 2 |
A | 7 | 1 | |
A | 7 | 2 | |
B | 1 | 1 | |
B | 1 | 2 | |
B | 3 | 1 | |
B | 3 | 2 | |
B | 5 | 1 | |
B | 5 | 2 | |
B | 7 | Pass | 1 |
B | 7 | Pass | 2 |
"i want to add a column where if status is pass then all the checkpoint before" does not make sense ☹️
Thanks for the example input table but please take time and effort to povide a example of the desired output with a clear description so we can all help you 😀😀😀
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
120 | |
77 | |
60 | |
54 | |
40 |
User | Count |
---|---|
191 | |
103 | |
87 | |
61 | |
50 |