Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |