Convert Excel IF + AND to Power Bi

[Barbara_olivier]

Dear all,

How to convert this following formula to power bi?

=IF(AND(F3=F2;M3>L2);L2-0,001;M3)

F column = product name 

L2 = smaller thickness of the same product with smaller width

M3 = larger thickness of product with greater width

[Greg_Deckler]

@Barbara_olivier There are exactly equivalent IF and AND statements in Power BI. Or you can use && instead of AND. To be more specific, would need sample data and expected output. Note, there is no way to reference a particular "cell" in Power BI. You have to use an aggregation and filtering.