Hi all,
I'm trying to use dax formulas to solve the total of the max value options for certain purchase numbers by supplier.
Please find example data below:
| Supplier Name | Purchase Number | Option | Total base Price |
| Supplier A | GEO012 | Option 1 | 20 |
| Supplier A | GEO043 | Option 1 | 30 |
| Supplier A | GEO043 | Option 2 | 35 |
| Supplier A | GEO045 | Option 1 | 10 |
| Supplier A | GEO046 | Option 1 | 12 |
| Supplier A | GEO046 | Option 2 | 15 |
| Supplier A | GEO055 | Option 1 | 20 |
| Supplier A | GEO055 | Option 2 | 30 |
| Supplier B | GEO037 | Option 1 | 30 |
| Supplier B | GEO037 | Option 2 | 20 |
| Supplier B | GEO043 | Option 1 | 35 |
| Supplier B | GEO043 | Option 2 | 36 |
Resulting Formula:
| Supplier Name | Max Quote Value |
| Supplier A | 110 |
| Supplier B | 66 |
Essentially what the formula will do for each purchase item the supplier will provide, it finds the max value between option 1 and option 2 and sum those values to find the max sum value. Some suppliers only provide 1 option.
Hope this makes sense. Any help would be greatly appreciated.
Thanks!
