Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am looking for some assistance. I have a list of body shops and appraisers. I want to create a calculated column that identifies and labels them accordingly. Essentially if they are in the order of "Word, Word" I want it to label as an <Appraiser> - all else, <Not an appraiser>.
Any Ideas?
Body Shop East, 1 |
Body Shop East, 2 |
Chris, Kyle |
Body Shop East, 3 |
Body Shop East, 4 |
Bob, Jim |
Body Shop East, 6 |
Solved! Go to Solution.
Maybe something like:
Column = VAR _right = RIGHT ( Table1[Column1], 1 ) RETURN IF ( ISERROR ( ISNUMBER ( VALUE ( _right ) ) ), "Appraiser", "Not an Appraiser" )
Proud to be a Super User!
Maybe something like:
Column = VAR _right = RIGHT ( Table1[Column1], 1 ) RETURN IF ( ISERROR ( ISNUMBER ( VALUE ( _right ) ) ), "Appraiser", "Not an Appraiser" )
Proud to be a Super User!
Works great. Thank you!
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |