DallDenmark
New Member
- Joined
- May 3, 2018
- Messages
- 5
I have a data set where below is an example.
I need to find the price with the latest start data, filtered by project no, task code and code.
So for Project no 032839-003 for code "E2" and task code "blank", the correct price is 725 since the latest start data is 01-01-2016.
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
How do I make a formula in Powerpivot, giving me this result?
I need to find the price with the latest start data, filtered by project no, task code and code.
So for Project no 032839-003 for code "E2" and task code "blank", the correct price is 725 since the latest start data is 01-01-2016.
Project No_ | Task Code | Work Type Code | Code | Start Date | Price |
032839-003 | SH | E2 | 01-01-2015 | 720 | |
040238-001 | SH | E2 | 01-01-2015 | 720 | |
032839-003 | SH | E2 | 01-01-2016 | 725 | |
040238-001 | SH | E2 | 01-01-2016 | 725 | |
032839-003 | 30.17.1000 | SH | E2 | 01-01-2016 | 725 |
040238-001 | 30.17.1000 | SH | E2 | 01-01-2016 | 725 |
032839-003 | 10.07.1000 | SH | E2 | 01-01-2016 | 825 |
040238-001 | 10.07.1000 | SH | E2 | 01-01-2016 | 825 |
032839-003 | 10.07.1000 | SH | E2 | 01-01-2015 | 815 |
040238-001 | 10.07.1000 | SH | E2 | 01-01-2015 | 815 |
032839-003 | 30.17.1000 | SH | E2 | 01-01-2015 | 815 |
040238-001 | 30.17.1000 | SH | E2 | 01-01-2015 | 815 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
How do I make a formula in Powerpivot, giving me this result?