https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-Find-min-and-max-date-based-of-slicer-values/m-p/715052#M1189 <P>Hello,</P><P>&nbsp;</P><P>You can use the following measure;<BR /><BR /><img /></P> Fri, 14 Jun 2019 09:14:08 GMT avanderschilden 2019-06-14T09:14:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-Find-min-and-max-date-based-of-slicer-values/m-p/714427#M1171 <P>&nbsp;</P><P>Hello,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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...</P><P>&nbsp;</P><P>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</P><P>&nbsp;</P><P>Data looks like...</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 13 Jun 2019 19:26:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-Find-min-and-max-date-based-of-slicer-values/m-p/714427#M1171 Anonymous 2019-06-13T19:26:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-Find-min-and-max-date-based-of-slicer-values/m-p/715052#M1189 <P>Hello,</P><P>&nbsp;</P><P>You can use the following measure;<BR /><BR /><img /></P> Fri, 14 Jun 2019 09:14:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-Find-min-and-max-date-based-of-slicer-values/m-p/715052#M1189 avanderschilden 2019-06-14T09:14:08Z