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
I would have 2 or more carers assigned to a client. As for change of UserType, once someone
is a Caregiver, they are always a Carer. Same for Client.
sorry Ive only had a chance to get back to you now
my first reaction would be to create two tables out of your users
one for Caregivers and one for users
to do that from your users table create a reference
give it a new name eg clients and filter out all the caregivers
now create relationships using the userid and the client id / caregiver ids
and you have a small model which can refer to each other, this should give you most of what you are looking to do, let me know if you have any issues and I can help you out