Forum Discussion
Finding Min Value within Column
Need to find min value by test group. From below example, expect
- Test Group (A) : Min = 12
- Test Group (B) : min = 10
I use below formula but didn't get correct result
Also try to use "Earlier" function but it keep showing error (cannot input parameter inside earlier).
Please help
Hi Anonymous , try this measure:
Min Group = CALCULATE(min('Table'[Sum of Qty]), ALLEXCEPT('Table','Table'[Test Group]) )The result:
Best regards
1 Reply
Hi Anonymous , try this measure:
Min Group = CALCULATE(min('Table'[Sum of Qty]), ALLEXCEPT('Table','Table'[Test Group]) )The result:
Best regards