Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Change slicer values

Hello all,

 

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. 

 

  • Try:

    test = IF(Incidents[operatorGroupId] = "580d91e7-6252-4b98-a0ca-06e6533f4b21","Audioproductie Rijswijk")

1 Reply

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion

    Try:

    test = IF(Incidents[operatorGroupId] = "580d91e7-6252-4b98-a0ca-06e6533f4b21","Audioproductie Rijswijk")