Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |