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 guys,
Can anyone help me how to make new column using measure to lookup the Grade below.
Type A, the bigger the Green is, and Type B is opposite.
So how can I run IF or Switch function?
The function I tried seems wrong,,
Thanks in advance.
Kim
Solved! Go to Solution.
Hi @jeongkim ,
You can create a calculated column as below in the table 'SKT' to get it:
Icon Grade =
SWITCH (
TRUE (),
'SKT'[Type] = 1
&& 'SKT'[Value] < 'SKT'[Red], 1,
'SKT'[Type] = 1
&& 'SKT'[Value] > 'SKT'[Red]
&& 'SKT'[Value] <= 'SKT'[Light-Red], 2,
'SKT'[Type] = 1
&& 'SKT'[Value] >= 'SKT'[Light-Green], 4,
'SKT'[Type] = 1
&& 'SKT'[Value] >= 'SKT'[Green], 5,
'SKT'[Type] = -1
&& 'SKT'[Value] >= 'SKT'[Red], 1,
'SKT'[Type] = -1
&& 'SKT'[Value] < 'SKT'[Red]
&& 'SKT'[Value] >= 'SKT'[Light-Red], 2,
'SKT'[Type] = -1
&& 'SKT'[Value] <= 'SKT'[Light-Green], 4,
'SKT'[Type] = -1
&& 'SKT'[Value] <= 'SKT'[Green], 5,
3
)
Best Regards
Hi @jeongkim ,
You can create a calculated column as below in the table 'SKT' to get it:
Icon Grade =
SWITCH (
TRUE (),
'SKT'[Type] = 1
&& 'SKT'[Value] < 'SKT'[Red], 1,
'SKT'[Type] = 1
&& 'SKT'[Value] > 'SKT'[Red]
&& 'SKT'[Value] <= 'SKT'[Light-Red], 2,
'SKT'[Type] = 1
&& 'SKT'[Value] >= 'SKT'[Light-Green], 4,
'SKT'[Type] = 1
&& 'SKT'[Value] >= 'SKT'[Green], 5,
'SKT'[Type] = -1
&& 'SKT'[Value] >= 'SKT'[Red], 1,
'SKT'[Type] = -1
&& 'SKT'[Value] < 'SKT'[Red]
&& 'SKT'[Value] >= 'SKT'[Light-Red], 2,
'SKT'[Type] = -1
&& 'SKT'[Value] <= 'SKT'[Light-Green], 4,
'SKT'[Type] = -1
&& 'SKT'[Value] <= 'SKT'[Green], 5,
3
)
Best Regards
also how can I add another condition? if the Value is (blank) then just leave it blank without grading?
Hi @jeongkim ,
You can update the formula of calculated column as below to get it:
Icon Grade = SWITCH ( TRUE (), ISBLANK ( 'SKT'[Value] ), BLANK (), 'SKT'[Type] = 1 && 'SKT'[Value] < 'SKT'[Red], 1, 'SKT'[Type] = 1 && 'SKT'[Value] > 'SKT'[Red] && 'SKT'[Value] <= 'SKT'[Light-Red], 2, 'SKT'[Type] = 1 && 'SKT'[Value] >= 'SKT'[Light-Green], 4, 'SKT'[Type] = 1 && 'SKT'[Value] >= 'SKT'[Green], 5, 'SKT'[Type] = -1 && 'SKT'[Value] >= 'SKT'[Red], 1, 'SKT'[Type] = -1 && 'SKT'[Value] < 'SKT'[Red] && 'SKT'[Value] >= 'SKT'[Light-Red], 2, 'SKT'[Type] = -1 && 'SKT'[Value] <= 'SKT'[Light-Green], 4, 'SKT'[Type] = -1 && 'SKT'[Value] <= 'SKT'[Green], 5, 3 ) |
Best Regards
Thank you so much! It is simpler and now working 🙂
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 | |
100 | |
86 | |
64 |