Find minimum value between two rows

Murali777 

Step 1: Create an INDEX to your TABLE  from the Transform tab

Step 2: Get the next name from Top to Bottom

Name +1 = CALCULATE(min(MinMaxGrp[Name]),FILTER(all(MinMaxGrp),MinMaxGrp[Index]=EARLIER(MinMaxGrp[Index])+1))

 

Step 3: Similarly Get the Next Value as well for the Name with the below calculation 

 

Value +1 = CALCULATE(min(MinMaxGrp[Value]),FILTER(all(MinMaxGrp),MinMaxGrp[Index]=EARLIER(MinMaxGrp[Index])+1))

 

Step 4:

Value -1 = CALCULATE(min(MinMaxGrp[Value]),FILTER(all(MinMaxGrp),MinMaxGrp[Index]=EARLIER(MinMaxGrp[Index])-1))

 

 

Step 5: Get the Max out of Two

 

Max =

 IF(MinMaxGrp[Name]="A", max(MinMaxGrp[Value],MinMaxGrp[Value +1]),max(MinMaxGrp[Value],MinMaxGrp[Value -1]))

 

Step 5:

Final Solution as (We will nullify the values against B and Will keep only one Value )

 

Solution Max = IF(MinMaxGrp[Name]=MinMaxGrp[Name +1],0, IF(MinMaxGrp[Value]=MinMaxGrp[Max],MinMaxGrp[Value],0))

 

 

NOTE: I did it for Max and you have to Use Min 🙂

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin

 

Murali777  Information not sufficient 

Ritesh

Hi Guys,

Please anyone help me on this.

I need to find the min values between two rows.

How are you grouping A and B,its not clear...

Hi Murali777 ,

Whether the advice given by ribisht17  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry