Forum Discussion
devenchj
Helper I
Helper IHow to Find Column's Minimum value based on other columns group
Hello Experts, trying to add new measure column which shows column's minimum value group by other column. tried with DAX function Summarize, MINX , but no luck. below is data sample, where ...
The way to achieve this is using EARLIER function:
Column = CALCULATE(MIN(Table1[TransitDays]),FILTER(Table1,Table1[Plant]=EARLIER(Table1[Plant])))
Hope this helps
Michael Shparber
Hi devenchj,
For the sample data, add an index column in Power Query Edit by selecting Index Column(from0,1) under Add column on home page.
Create a measur using the formula.Measure = MINX(FILTER(SELECTCOLUMNS(ALLSELECTED(Table2),"index",Table2[Index],"Min",MINX(FILTER(Table2,Table2[Plant]=EARLIER(Table2[Plant])),Table2[Value])),[index]=MAX(Table2[Index])),[Min])
Please see the screenshot, it will calculate the min value based on [Plant] field in diferrent months.
You can dowbload mine .pbix file, and test using Table2.
Best Regards,
Angelia
Sean
Community Champion
Community ChampionHow about this...
Min Transit Days by Plant = CALCULATE ( MIN ( Table[Transit Days] ), ALLEXCEPT ( Table, Table[Plant] ) )
- devenchj
Hi Sean, thanks for your help.
this formula is giving wrong result in table visualization
tangutooriHelper III
minvalue =Var MIn_val_pla = CALCULATE(min('Table'[Trnsis days]),ALLEXCEPT('Table','Table'[Plant]))Return MIn_val_pla
