Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello ,
Good Morning !
I would like to calculate the maximum value in each line between 30 columns, but I can not find a formula that allows me to do this, f I would like to build a new column that returns the value to me maximum between.
@Anonymous if you want to do it with dax it will be complex. You will end up with writing nested max function.
Better approach is go to edit query>> select all 30 columns >> click on add column >> Click on statics and choose maximum
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 10 | |
| 10 | |
| 6 | |
| 6 |