Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Example table below. The Column C is the minimum across columns A and B for the same row. The final, evaluated number is the sum of all the values in COlumn C. I'm lost as to how I'd implement this simple calculation in powerbi. Any help will be greatly appreciated.
A | B | C = min (A,B) |
20 | 50 | 20 |
30 | 50 | 30 |
45 | 50 | 45 |
67 | 50 | 50 |
90 | 50 | 50 |
88 | 50 | 50 |
Sum of Col C | 245 |
Solved! Go to Solution.
@Anonymous , Try a new measure like
sumx(Table, if([A]>[B], [A], [B]))
Else create a new column and then have sum
C = if([A]>[B], [A], [B])
Thanks - it works perfectly. Much appreciated.
A follow up question, if I may - is there a way to create a data table like in excel with the 'B' values varying from say 25 to 200, and the resultant sumx(Table, if([A]>[B], [A], [B])) providing the output in an adjacent column?