Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Let's say I have categories A, B, and C all in one column. Can I create a measure that translates the column into A -> 1, B -> 2, C -> 3? Thanks!
Solved! Go to Solution.
@DaxPadawan , You should prefer a new column in such measure can do that but will not work as slicer or group by
Switch([Column],
"A",1,
"B",2,
"C",3)
Hi @DaxPadawan
Based on available info:
=
SWITCH ( SELECTEDVALUE ( 'Table'[Category] ), "A", 1, "B", 2, "C", 3 )
Proud to be a Super User!
@DaxPadawan , You should prefer a new column in such measure can do that but will not work as slicer or group by
Switch([Column],
"A",1,
"B",2,
"C",3)
Hello @amitchandak , what do you mean it will not work as a slicer or group by?
Hi, @DaxPadawan
You need to note that you can't put measure into a slicer.
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
94 | |
86 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |