i am new to POwer BI. In QlikView you could load a value in a data table for Example the data table was: Name. But inside the Data table there was Chris, John and Peter. But he load script would make lets say Chris display as Manager and John as Head Of Department. So the script would look something like this:
if(Name = 'Chris', 'Manager', if(Name = 'John', 'head of Department')) as Name.