display the 2 largest values for individual months

[milanSVK]

hello, could you advise how to display the 2 largest values for individual months on the cart visual

[milanSVK]

my expected result for the month of November, see photo

[Anonymous]

Hi @milanSVK 

You need your solution for particular one month(last month) or for every month

[tamerj1]

Hi @milanSVK 
Do you mean a card for each individual month?

[tamerj1]

@milanSVK 

Please try

Card =
MINX ( TOPN ( 2, VALUES ( 'Table'[Value] ), 'Table'[Value] ), 'Table'[Value] )

[milanSVK]

yes this solution will display the 2 largest value but despite all the values. I would still need to modify it to display the 2 largest value of the last month

[tamerj1]

@milanSVK 

Card =

MAXX (

TOPN ( 1, VALUES ( 'Date'[YearMonth] ),

CALCULATE (
MINX ( TOPN ( 2, VALUES ( 'Table'[Value] ), 'Table'[Value] ), 'Table'[Value] )

)

)

[milanSVK · Accepted solution]

Hi @tamerj1 
thank you for the advice, in the end I implemented the following solution.
1.thank you for the advice, in the end I implemented the following solutionthank you for the advice, in the end I implemented the following solution

"previosMONT =

VAR caltab_= CALCULATETABLE(all_syntezy,all_syntezy[Datum]=MINX(TOPN(2,VALUES(all_syntezy[Datum]),all_syntezy[Datum]),all_syntezy[Datum]))

return

caltab_"
=>and then I created a liquid metric 👉

CARDpreviosMonth=

VAR TOPpramater = 1

VAR hodnota = MINX ( TOPN ( TOPpramater, VALUES ( previosMONT[CELKOM]), previosMONT[CELKOM] ), previosMONT[CELKOM] )

VAR text_ = FORMAT(hodnota,"0,0")

return

COMBINEVALUES(" ", "TOP",TOPpramater," customer :",    LOOKUPVALUE(lastMONT[NAME],lastMONT[CELKOM],hodnota),".With the amount :",text_,"💲",".For the period",[🔤nameActualMonth])

I finally found the right metric
👉👉

Card👍 =

CALCULATE(

    MINX(TOPN(1,VALUES(all_syntezy[CELKOM]),all_syntezy[CELKOM]),all_syntezy[CELKOM]),

        all_syntezy[Datum]=MINX(TOPN(1,VALUES(all_syntezy[Datum]),all_syntezy[Datum]),all_syntezy[Datum])

        )
🐬📶