Convert Excel MINIFS to POWER BI

[Barbara_olivier]

Dear All,

How can i convert following excel formula into power bi: 

=MINIFS($AD$2:$AD$8000;$F$2:$F$8000;F3;$BF$2:$BF$8000;Q3)

$F$2:$F$8000 - Product code

F3 = Product code of the line analysed

$AD$2:$AD$8000 = Thickness of product

$BF$2:$BF$8000 = Width of product

Q3 = ">= Max width of product"

[Greg_Deckler · Accepted solution]

@Barbara_olivier The general form is MINX(FILTER(...), ...) or CACULATE(MIN(...), FILTER(...))

L-M Excel to DAX Translation - Microsoft Power BI Community