Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Lookup Min/Max

This one or some variation of it comes up constantly in the forums so I'm surprised that there is no pattern in the Quick Measure Gallery for dealing with it. The problem generally goes along the lin...
Filters
Mathematical
Other
Alyona_BI's avatar
Alyona_BI
Icon for Helper II rankHelper II
6 years ago

Hi Greg_Deckler!

 

Many thanks for your solution. But is there a way to calculate the same with help of calculated column (not as measure as in your example)? 

 

Thanks in advance!

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Alyona_BI - Absolutely, the same technique will work with a calculated column. You may have to use EARLIER to filter down to the correct rows. Hard to be specific.