Forum Discussion

ryan_b_fiting's avatar
ryan_b_fiting
Post Patron
4 years ago
Solved

MIN Value in Calculated Column

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 DescSq Feet
Saxon2560
Saxon2600
Cypress3121
Cypress3150

 

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 DescSq FeetHouse Plan Group
Saxon2560Saxon | 2560
Saxon2600Saxon | 2560
Cypress3121Cypress | 3121
Cypress3150Cypress | 3121

 

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

 

Thanks Community!

Ryan

Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • ribisht17's avatar
    ribisht17
    4 years ago

    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

2 Replies

  • ribisht17's avatar
    ribisht17
    Super User
    4 years ago

    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