Forum Discussion
First Minimum, Second Minimum and 3rd minimum value calculation
Dear All, i am new to DAX and i want to know that how to calculate first min, second min and third min value in a column. i.e. Item Amount 123444556 60 123444556 90 123...
Greg_Deckler
Community Champion
Community ChampionDepending on your requirement:
RankX1 = RANKX('Table',[Amount],,ASC)
or
RankX2 = RANKX(FILTER('Table',[Item]=EARLIER('Table'[Item])),[Amount],,ASC)
You can then just filter for 1-3 in any visual.
Thanks