I'm trying to change the values of column operatorGroupId and put these changed values into a new column.
So far I've tried the following:
test = IF(Incidents[operatorGroupId], "580d91e7-6252-4b98-a0ca-06e6533f4b21","Audioproductie Rijswijk") - gives error that it cannot convert ''580d etc'' from a text based to a true/false.
test = IF(Incidents[operatorGroupId]=FALSE(), "580d91e7-6252-4b98-a0ca-06e6533f4b21","Audioproductie Rijswijk") - Error that DAX does not support comparing values of type text with values of type true/false
Any ideas how this is done otherwise?
Part of the reason why I'm doing this is because the table for operatorGroupId (OperatorGroups) doesn't want to active a many to one relationship because another look up table (IncidentTypes) already has a similar relation with the Incidents table. I'm confused as to why it refuses because both IncidentTypes & OperatorGroups are look up tables. The above problem can be solved by this one, but I am happy for either solution.