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 want to generate Requirement column based on below 3 columns...
Date---------- | Name | Status | Requirement |
11-Jan-22 | ABC | P | ABC-P-1 |
11-Feb-22 | ABC | P | ABC-P-1 |
11-Mar-22 | ABC | A | ABC-A-2 |
11-Apr-22 | ABC | A | ABC-A-2 |
11-May-22 | ABC | A | ABC-A-2 |
12-May-22 | ABC | A | ABC-A-2 |
13-May-22 | ABC | P | ABC-P-3 |
14-May-22 | ABC | A | ABC-A-4 |
15-May-22 | ABC | A | ABC-A-4 |
11-Jan-22 | DEF | P | DEF-P-1 |
11-Feb-22 | DEF | A | DEF-A-2 |
11-Mar-22 | DEF | A | DEF-A-2 |
11-Apr-22 | DEF | P | DEF-P-3 |
11-May-22 | DEF | P | DEF-P-3 |
12-May-22 | DEF | A | DEF-A-4 |
13-May-22 | DEF | A | DEF-A-4 |
14-May-22 | DEF | P | DEF-P-5 |
15-May-22 | DEF | P | DEF-P-5 |
@ddpl , Can you share the expected value?
For Rank Refer to these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
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 |
---|---|
103 | |
103 | |
87 | |
73 | |
66 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |