The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
Please use a measure with similar formula as below.
Measure = CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )
Best Regards,
Herbert
Please use a measure with similar formula as below.
Measure = CALCULATE ( MAX ( 'Calendar'[Date] ), ALLSELECTED ( 'Calendar' ) )
Best Regards,
Herbert