I have 2 fields: Manager Name & Employee Type in which I need to use as criteria for a formula. What I want to do is create a measure or calculated column in a table visual that looks at the Manager name and then looks at employee type to return whether the manager is managing just employees, contractors or employees & contractors. I'm working on a manager reconciliation exercise. Employee Type only has two options: Employee and Contractor
So for example, the output would look like this in a table visual:
Manager ID Manager Name Managing?
11112 Frog, Kermit Employees Only
12231 Blue, Gonzo Contractors Only
12334 Piggy, MIss Employees & Contractors
Raw data looks like this:
I tried a few different logic scenarios but I can't seem to get it right. Any help would be great please. Thanks!
Thank you for this. Unfortunately, I cannot seem to do that as "Employee Type" is a group I used to roll the 7 different types of people into two buckets. I tried doing it as a calculated column, but wouldn't show up on field list.