Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello, do you have any recommendations pleas for using the 'MIN' function to replicate the results calculated in Excel as per example below? When I try to use it fpor my expression, I get an error due to MIN function only working with column as a reference:
| B | C | D | E | F | ||||||
| Row | Column | |||||||||
| 3 | C 01.00 | 020 | 010 | 187827795 | ||||||
| 4 | less | |||||||||
| 5 | C 05.01 | 010 | 010 | 1975250 | ||||||
| 6 | less | |||||||||
| 7 | C 01.00 | 440 | 010 | 0 | ||||||
| 8 | plus | |||||||||
| 9 | MINIMUM{ | |||||||||
| 10 | C 01.00 | r530 | c10 | 0 | ||||||
| 11 | less | |||||||||
| 12 | C 01.00 | r740 | c10 | 0 | ||||||
| 13 | less | |||||||||
| 14 | C 05.01 | r010 | c020 | 0 | ||||||
| 15 | less | |||||||||
| 16 | C 01.00 | r720 | c10 | 0 | ||||||
| 17 | plus | |||||||||
| 18 | minimum[ | |||||||||
| 19 | C 01.00 | r750 | c10 | 52131120 | ||||||
| 20 | less | |||||||||
| 21 | C 01.00 | r970 | c10 | 0 | ||||||
| 22 | less | |||||||||
| 23 | C 05.01 | r010 | c030 | 0 | ||||||
| 24 | ,0] | |||||||||
| 25 | ,0} | 185,852,545 | =F3-F5-F7+MIN(F10-F12-F14-F16+(MIN(F19-F21-F23,0)),0) |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 11 | |
| 8 | |
| 8 | |
| 8 |