Forum Discussion
Convert Excel IF + AND to Power Bi
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
1 Reply
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.
