Forum Discussion
DAX Formula that sums the max values
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!
2 Replies
- Ahmedx
Super User