The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
User | Count |
---|---|
85 | |
84 | |
36 | |
34 | |
31 |
User | Count |
---|---|
92 | |
79 | |
66 | |
55 | |
52 |