Forum Discussion
MIN Formula
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 |
2 Replies
Mayank09sharma , Are you expecting this?
Min of Plan= MIN('Table'[Plan])Min of Target = MIN('Table'[Target])If [Target] and [Plan] are measures then
MINX (
ALLSELECTED ( 'Table'[Particular] ), [Target]
)
