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

[anilkalidhindi]

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.

[v-haibl-msft]

@anilkalidhindi

Does above solution help?

Best Regards,
Herbert

[v-haibl-msft · Accepted solution]

@anilkalidhindi

Please use a measure with similar formula as below.

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

Best Regards,
Herbert