MIN Formula

[Mayank09sharma]

I am trying to add a new measure of MIN for the column Target and Plan. Could anyone help me with this?

Particular	Plan	Target
ABC	67669	54618
YTD	161083	731453
DSF	15224	951020
NJN	884000	611637
KSM	56752	5785165
AMC	30009	4059145
NJN	5866023	1328
LML	2565	257224
AAA	941904	4356724
ALL	27493145	1045457
OIL	7987624	4586814
MNH	3210656	316924
EGG	1491850	1407924
JULY	1185545	408045
SHE	90309	4316124

[tamerj1]

Hi @Mayank09sharma 

If [Target] and [Plan] are measures then

MINX (

ALLSELECTED ( 'Table'[Particular] ), [Target] 

)

[Arul]

@Mayank09sharma , Are you expecting this?

Min of Plan= MIN('Table'[Plan])

Min of Target = MIN('Table'[Target])