Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
That worked perfectly. Thank you!
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |