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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |