michiel_soede
New Member
- Joined
- Oct 7, 2009
- Messages
- 15
All,
I have attached simplified data set.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Is it possible in power query to select / query the first asset after I have sorted on priority? I can't simply select the status where I don't have the same transaction types for all assets (so for one asset I have new and terminated and for others ceased and new for example). Therefore I need to pick the first prioritized transaction per group of transaction for each asset.
Thanks for your help
Michiel
I have attached simplified data set.
Asset | Status | Priority | Timestamp |
A | Terminate | 1 | 13-Oct-18 |
A | New | 4 | 13-Oct-18 |
B | Terminate | 1 | 13-Oct-18 |
B | Change | 3 | 13-Oct-18 |
C | Terminate | 1 | 13-Oct-18 |
C | Change | 3 | 13-Oct-18 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Is it possible in power query to select / query the first asset after I have sorted on priority? I can't simply select the status where I don't have the same transaction types for all assets (so for one asset I have new and terminated and for others ceased and new for example). Therefore I need to pick the first prioritized transaction per group of transaction for each asset.
Thanks for your help
Michiel