Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

To Find min and max date based of slicer values

 

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...

Photo.PNG

 

 

1 REPLY 1
avanderschilden
Resolver I
Resolver I

Hello,

 

You can use the following measure;

Capture.PNG

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.