Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Replace values

Hi,

 

I have a list with the request updated manually by human or system as per below (Table 1) and i would like to replace those human name with Manual and remain the System as System like (Table 2). May I know how to transform it?

 

Table 1

Request #Updated by
1Dave
2Ken
3System
4Dana
5Sandy
6Amanda
7Vivian
8System
9Sandy
10Ken

 

Table 2

Request #Updated by
1Manual
2Manual
3System
4Manual
5Manual
6Manual
7Manual
8System
9Manual
10Manual

 

Thank you.

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    Column = if('Table'[updated by]="System","System","Mannual")
    or in Pq
    if [updated by]="System" then "System" else "Mannual"
    then remove the updated by column

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    Anonymous 

    Column = if('Table'[updated by]="System","System","Mannual")
    or in Pq
    if [updated by]="System" then "System" else "Mannual"
    then remove the updated by column