Forum Discussion
Row Context in Calculated Column
Hello, I have a data model that looks like this: Registrations contains a list of people, and the date they registered. I want to be able to count Registrations filtering by the ...
staff members move around over time (and we have no clean data on this in the model) Maybe you want to fix that? Read about SCD2.
Thanks lbendlin
I've looked into slowly changing data previously (we don't use it in our model). Our working practices (we're a small community hub) are such that staff overlap between projects - for example our front desk does most (but not all) of the registrations and is assigned to a particuarly project - but staff from other projects will cover this role, say for the lunch break.
Therefore there isn't really a clean way of acheive what we need (I don't think) other than some sort of fomula to determine the first project a contact engaged with?
Thanks,
Adam