Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have data something like this:
Catagory | value | final value |
A | 1 | 1 |
A | 2 | 1 |
B | 2 | 2 |
B | 3 | 2 |
B | 4 | 2 |
Basically number 1,2,3,4 are priority and if any atagory has prio 1 also 2 assign both to 1.
Solved! Go to Solution.
It sounds like you are just trying to get the min of each group /category is that right?
You'll need an expression like
Pi
The solution then is something like this:
Catagory | value | final value |
A | 5 | 5 |
A | 7 | 5 |
B | 7 | 6 |
B | 6 | 6 |
C | 5 | 5 |
C | 6 | 5 |
C | 5 | 5 |
C | 6 | 6 |
Condition 1: Cat A --> Assign prio 5 only if 6 is not there against A.
Condition 2: Cat B --> Assign prio 6 only if 5 is not present against B.
Condition 3: Cat C --> If prio 5 and 6 both present against C, assign random 75% 5's to cat C and in rest 25%, 6's.
The solution then is something like this:
It sounds like you are just trying to get the min of each group /category is that right?
You'll need an expression like
Pi
DAX would be good for me, I dont want to go on Mquery for this
Hi prat_daxer,
Are you trying to do this with DAX (front end UI) or M query (data shaping and modelling)
Pi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |