Forum Discussion
Creating a new column if values in column 1 = column 2
if you are doing this in Power Query then
this should do it
=if [usertype]="caregiver" then [Fullname] else ""
if you are creating a calculated column then its
Caregiver = if(users[UserType]="caregiver",users[Fullname],BLANK())
The first part of an IF is to check the logic so it checks to see if the first expression is true or false
then the second part is what is returned if its TRUE
and the last if it is false
Helper ICool,
In order to get to the stage where you can match up a Client to the Caregiver, you will need something in your base table that actually shows this relationship.
Just looking at the columns [Full Name] , [User Type]
We dont have any information to say that a Caregiver has a relationship to a client or vice versa.
Normally I would expect a table to look bit like this (at the minimum)
[Id] , [Full Name], [User Type], [Assgined Carer Id]
Other questions come to mind, like would you have a situation where you might have two carers associated to a single client?
would you have a change in carer and how do you keep track of the change?
Post PatronHi,
I have two tables, Users & Service Task. Users has 4 columns -> Fullname (a mix of carers & clients) , UserType(Client or Caregiver) and UserTypeID (1 = Caregiver, 2= Client) and UserID
Service Task table contains CareGiverID & Client ID