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 ...
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
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