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
anilkalidhindi
New Member

Need MAX and MIN date of filtered data set in report rather than entire dataset.

I need to calculate the MAX and MIN of the filtered data set. I have use all the MAX functions, Calculate and Filter functions. I need to be able to calculate the MAX and MIN dates in my filter data set of  the report rather than entire dataset. Please advise.date filter issue.PNG

1 ACCEPTED SOLUTION
v-haibl-msft
Microsoft Employee
Microsoft Employee

@anilkalidhindi

 

Please use a measure with similar formula as below.

 

Measure =
CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )

Need MAX and MIN date of filtered data set in report rather than entire dataset_1.jpg

 

Best Regards,
Herbert

View solution in original post

2 REPLIES 2
v-haibl-msft
Microsoft Employee
Microsoft Employee

@anilkalidhindi

 

Does above solution help?

 

Best Regards,
Herbert

v-haibl-msft
Microsoft Employee
Microsoft Employee

@anilkalidhindi

 

Please use a measure with similar formula as below.

 

Measure =
CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )

Need MAX and MIN date of filtered data set in report rather than entire dataset_1.jpg

 

Best Regards,
Herbert

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.

Top Solution Authors