Greetings,
I'm a big fan of Power Pivot, I struggle on 1 point, even after having read Rob's book on DAX, I can't solve my problem.
I used to calculate my KPIs using vlookups and pivot tables.
One of the data I used:
Raw data (Sheet1):
<tbody>
</tbody>
PivotChart (Sheet2):
<tbody>
</tbody>
Summary Sheet (Sheet3):
<tbody>
</tbody>
Then I do many pivot table with calculated fields to get my KPIs.
My problem:
How do you get the start date and the end date sorted out from sheet 1 using PowerPivot?
I can't figure the DAX formula to use.
Many thanks in advance for your help.
Regards
Buhlo
I'm a big fan of Power Pivot, I struggle on 1 point, even after having read Rob's book on DAX, I can't solve my problem.
I used to calculate my KPIs using vlookups and pivot tables.
One of the data I used:
Raw data (Sheet1):
Job | Date |
1223 | 03/04 |
1223 | 05/04 |
1223 | 06/04 |
2334 | 02/04 |
5698 | 01/04 |
.... |
<tbody>
</tbody>
PivotChart (Sheet2):
Job | Start date | End date |
1223 | 03/04 | 06/04 |
2334 | 02/04 | ... |
5698 | 01/04 | ... |
<tbody>
</tbody>
Summary Sheet (Sheet3):
Job | Content (vlookup sheet x) | Shopfloor (vlookup sheet x) | Start date (Vlookup sheet2) | End date (vlookup sheet2) | article number (vlookup sheet x) | Planned start date (vlookup sheet x).... | .... | ... | .... |
1223 | 03/04 | 06/04 | |||||||
.... |
<tbody>
</tbody>
Then I do many pivot table with calculated fields to get my KPIs.
My problem:
How do you get the start date and the end date sorted out from sheet 1 using PowerPivot?
I can't figure the DAX formula to use.
Many thanks in advance for your help.
Regards
Buhlo