Excel BI Challenge Workout 018

Workouts Excel BI Challenge
21

LinkedIn Post by:
محمد حلمي

=FILTER(A2:A10;BYROW(B2:D10;LAMBDA(a;SUM(LARGE(a;{2;3}))>MAX(a))))

22

LinkedIn Post by:
Apostolos Goulandris

=FILTER(A2:A10, BYROW(B2:D10,LAMBDA(a,SUM(SMALL(a,{1,2}))>MAX(a))) )

23

LinkedIn Post by:
Jardiel Euflázio
 

=FILTER(
A2:A10,

MAP(
B2:B10,
C2:C10,
D2:D10,

LAMBDA(
a,b,c,AND(a+b>c,a+c>b,b+c>a)

)

)

)
24

Linkedin Post by:
Jardiel Euflázio
 

=FILTER(

A2:A10,

IF(B2:B10+C2:C10>D2:D10,
IF(C2:C10+D2:D10>B2:B10,
IF(B2:B10+D2:D10>C2:C10,1

)
)
)
)
25

LinkedIn Post by:
Tyler N.

=UNIQUE(FILTER(A2:A10;(B2:B10+C2:C10>D2:D10)*(C2:C10+D2:D10>B2:B10)*(D2:D10+B2:B10>C2:C10)))

26

LinkedIn Post by:
محمد حلمي

=LET(b;B2:B10;c;C2:C10;d;D2:D10;FILTER(A2:A10;(b+c>d)*(c+d>b)*(d+b>c)))

27

LinkedIn Post by:
Matthias Friedmann

Power Query filtering the rows [and removing the other columns]:

let
 Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
 #"Filtered Rows" = Table.SelectRows(Source, each 
if List.Max({[Side 1], [Side 2], [Side 3]}) = [Side 1] then [Side 1] < [Side 2]+[Side 3] else
if List.Max({[Side 1], [Side 2], [Side 3]}) = [Side 2] then [Side 2] < [Side 1]+[Side 3] else
if List.Max({[Side 1], [Side 2], [Side 3]}) = [Side 3] then [Side 3] < [Side 2]+[Side 1] else null)[[Triangle]]
in
 #"Filtered Rows"