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.
Hi All,
I'm trying to create a new ranked column based on a few if rules that need to be looped over.
The data looks like this with the ApplicationCycle column being the desired ranked column:
TABLE1
InteractionKey | MarketingInteraction | CourseTitle | Application Cycle |
7 | Application made | Master of Arts in Digital Asset and Media Management | 1 |
9 | Conditional Offer | Master of Arts in Digital Asset and Media Management | 1 |
7 | Application made | 6-week Combined Pre-sessional Programme | 2 |
15 | Firmly accpt offer | Master of Arts in Digital Asset and Media Management | 1 |
14 | Enrolled | Master of Arts in Digital Asset and Media Management | 1 |
21 | Reject | 6-week Combined Pre-sessional Programme | 2 |
7 | Application made | Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3 | 3 |
23 | Unconditional Offer | Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3 | 3 |
15 | Firmly accpt offer | Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3 | 3 |
8 | ATRd | Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3 | 3 |
14 | Enrolled | Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3 | 3 |
7 | Application made | Master of Arts in Digital Asset and Media Management | 4 |
9 | Conditional Offer | Master of Arts in Digital Asset and Media Management | 4 |
8 | ATRd | Master of Arts in Digital Asset and Media Management | 4 |
15 | Firmly accpt offer | Master of Arts in Digital Asset and Media Management | 4 |
14 | Enrolled | Master of Arts in Digital Asset and Media Management | 4 |
So far, from my understanding the code should be something like this:
ApplicationCycle=
Start LOOP from first unranked row in [ApplicationCycle] :
Foreach(row in [InteractionKey]):
IF([InteractionKey]= "7") START RANKX (TABLE1 , [InteractionKey])
IF([InteractionKey]= "7") again SKIP RANKX
IF([InteractionKey]= " 6,10,21,24,14") STOP RANKX
End LOOP
Any advice, tips and pointers to this will be much appriciated.
Thanks,
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 |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |