Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Get minimum value by category.

Hello,

 

I have issue to get the min value by company name.

The output should be like below.

Kindly please help me to get the Min Sales column

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi,

     

    Please use the following dax as a new column

     

    Min sales = CALCULATE(
        MIN('Table (2)'[Sales]),
        FILTER(
            'Table (2)', 'Table (2)'[Company] = EARLIER( 'Table (2)'[Company])))

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

     

    Please use the following dax as a new column

     

    Min sales = CALCULATE(
        MIN('Table (2)'[Sales]),
        FILTER(
            'Table (2)', 'Table (2)'[Company] = EARLIER( 'Table (2)'[Company])))