To Find min and max date based of slicer values

[Anonymous]

Hello,

I'm new to Power BI and creating a report which needs to calculate the min and max date based on selection of value in slicer. Col 1 contains department, Col 2 contains project name, col 3 contains start date of project and col 4 contains its end date.

Customer needs 2 slicers, one for Department and other for Project Name. If Customer just selects P1 for slicer 2 then MIn and Max date should be 2/23/2014 and 10/28/2017...

Also can we find both the dates in same column as two values...as i want to use these dates as values for x-axis

Data looks like...

[avanderschilden]

Hello,

You can use the following measure;