MIN Value in Calculated Column

[ryan_b_fiting]

Hello Community - 

I have some housing data that I am trying to create a calculated column with.  I have data for a House Plan Desc and Square Ft.  See Below:

House Plan Desc	Sq Feet
Saxon	2560
Saxon	2600
Cypress	3121
Cypress	3150

I am looking to create a calcluated column that will combine the House Plan Desc with the MIN Sq Feet value for that plan.

For the above example the Calculated column would show this:

House Plan Desc	Sq Feet	House Plan Group
Saxon	2560	Saxon | 2560
Saxon	2600	Saxon | 2560
Cypress	3121	Cypress | 3121
Cypress	3150	Cypress | 3121

Is there a quick and efficient way to create that new "House Plan Group" column?

Thanks Community!

Ryan

[ribisht17 · Accepted solution]

@ryan_b_fiting 

This should work 

Solution = CONCATENATE('Table'[House Plan Desc],FORMAT( CALCULATE(MIN('Table'[Sq Feet]),ALLEXCEPT('Table','Table'[House Plan Desc]))," | ####"))

Thanks,

Ritesh

[ryan_b_fiting]

@ribisht17 works perfectly!  Forgot to use the ALLEXCEPT!  Thanks for the insight and quick response!