Load data via load script

[AndreTru]

Hi All

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.

Any help would be great.

[v-frfei-msft · Accepted solution]

Hi @AndreTru,

Based on my test, we can add a calculate column to meet your requirement.

header = IF('name'[Name]= "Chris","Manager",IF('name'[Name]="John","head of Department"))

The result as below.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/dkpz3awbrdbw5wp/Load%20data%20via%20load%20script.pbix?dl=0

Regards,
Frank

[AndreTru]

Hello

Thanks for the reply, but I don't even know where to start with this!!!

Can you help?

TIA

regards

Andre

[v-frfei-msft]

Hi @AndreTru,

Just click the Data icon, then you will get this page. And right click any column to create a new column.

 

Regards,

Frank

[v-frfei-msft]

Hi @AndreTru,

Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

Regards,
Frank