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, I am looking to add a new column that will go through all of the 'Scores' I have and check what type it is. If it is Type A I want to divide the 'Score' by 50 and if it is Type B to divide the 'Score' by 25.
Exmaple below:
Project | Score | Type | Answer |
Project 1 | 100 | A | 2 |
Project 2 | 75 | B | 3 |
Project 3 | 25 | A | 12.5 |
Solved! Go to Solution.
New calculated column:
NewColumn = SWITCH(
TRUE(),
[Type] = "A", DIVIDE( [Score], 50, 0 ),
[Type] = "B", DIVIDE( [Score], 25, 0 ))
This should get you what you asked for.
Regards,
Hi, it seems putting in the word SWITCH is giving me an error
"Expression.Error: The name "SWITCH" wasn't recognized. Make sure it's spelled correctly."
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |