The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |