topic Re: display the 2 largest values for individual months in DAX Commands and Tips

display the 2 largest values for individual months

milanSVK — Wed, 15 Mar 2023 11:31:33 GMT

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

Re: display the 2 largest values for individual months

tamerj1 — Wed, 15 Mar 2023 11:58:28 GMT

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

Re: display the 2 largest values for individual months

milanSVK — Wed, 15 Mar 2023 14:17:43 GMT

my expected result for the month of November, see photo

Re: display the 2 largest values for individual months

tamerj1 — Wed, 15 Mar 2023 14:48:37 GMT

milanSVK

Please try

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

Re: display the 2 largest values for individual months

milanSVK — Wed, 15 Mar 2023 16:40:42 GMT

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

Re: display the 2 largest values for individual months

Anonymous — Wed, 15 Mar 2023 16:48:36 GMT

Hi milanSVK

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

Re: display the 2 largest values for individual months

tamerj1 — Thu, 16 Mar 2023 03:01:41 GMT

milanSVK

Card =

MAXX (

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

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

)

Re: display the 2 largest values for individual months

milanSVK — Thu, 16 Mar 2023 21:47:51 GMT

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])

)
🐬📶