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.
I have three columns, "Part Number", "Fixed Rate" and "Non-Fixed Rate". There will be either a value, greater than 0, in "Fixed Rate" or "Non-Fixed Rate". There will never be a value greater than 0 in both.
Part_Number Fixed_Rate Non-Fixed_Rate Measure Value
CH 1234 0 125.00 187.50
CH 2345 100.00 0 150.00
CH 3456 0 150.00 225.00
I need a measure that will look at both columns, pull the one value it finds greater than 0, and times it by 1.5.
In excel, it would look like this.
=max(B2,C2)*1.5
Solved! Go to Solution.
I think I found the answer. This looks like it is working correctly.
Measure = MAXX(Pricing,max(Pricing[Standard Aero Fixed Flat Rate],Pricing[Standard Aero Non-Fixed Flat Rate]))*1.5
I think I found the answer. This looks like it is working correctly.
Measure = MAXX(Pricing,max(Pricing[Standard Aero Fixed Flat Rate],Pricing[Standard Aero Non-Fixed Flat Rate]))*1.5
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |