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
So I have the following data set:
| group | rnk | buckets | # loans |
| bucket | 1 | -0 | 345 |
| bucket | 1 | -0 | 5467 |
| bucket | 1 | 12 | 453 |
| bucket | 1 | 12 | 22 |
| bucket | 1 | 12 | 125 |
| bucket | 2 | 14 | 2565 |
| bucket | 2 | 14 | 4232 |
| bucket | 2 | 14 | 213 |
| bucket | 2 | 17 | 123 |
| bucket | 2 | 17 | 12 |
| bucket | 2 | 17 | 45 |
| bucket | 2 | 17 | 567 |
I need to create a new column that looks for the Minimun value of those groups taking into consideration that there are multiple type of groups instead of buckets and the rankc column alongside with the buckets will change. So for example:
| group | rnk | buckets | # loans | Min value |
| bucket | 1 | -0 | 345 | 345 |
| bucket | 1 | -0 | 5467 | 345 |
| bucket | 1 | 12 | 453 | 22 |
| bucket | 1 | 12 | 22 | 22 |
| bucket | 1 | 12 | 125 | 22 |
| bucket | 2 | 14 | 2565 | 213 |
| bucket | 2 | 14 | 4232 | 213 |
| bucket | 2 | 14 | 213 | 213 |
| bucket | 2 | 17 | 123 | 12 |
| bucket | 2 | 17 | 12 | 12 |
| bucket | 2 | 17 | 45 | 12 |
| bucket | 2 | 17 | 567 | 12 |
As you can see a new column is added with the MIN value of the data as mentioned above. How can I do this using DAX?
hi @HIGGS1989
try like:
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 21 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 20 | |
| 13 | |
| 12 |