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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |