DAX formula to get multiple min-max values on multiple inputs

[Buhloit]

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):

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

 

[Jacob Barnett]

Buhlo, welcome to the forum!

Unless I'm missing something I suspect you are just trying to over complicate things.

[Min] = MIN(data[Date])
[Max] = MAX(data[Date])

Once you pull the 'Job' into into the row header that creates the filter context for each row and you will automatically get the Min/Max date for each Job from the data table.

HTH
Jacob

 

[Buhloit]

Hello Jacob,
I was indeed over complicating things!
Thanks for your answer.
Buhlo

 

[CLEARIFY]

So how would you find the minimum date used in a related fact table? - regardless of measure?