Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PQ How to replace 1 to 0 ?

Hi All  
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    The operation in Power Query will be used for the entire column. Currently it's not support the change the value of single row.

    You may submit this as an idea.

    https://ideas.powerbi.com/ideas/ 

     

    Best Regards,

    Jay

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

I agree you should change it in the source.  For a short-term fix, you could add a custom column with

 = [User] = "[email protected]" then 0 else [IsManager]

 

Regards,

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Mahoney

    Thank you for sharing. 

    I don't understand why i need to create condition , since i only need to edit the table data. 

    Paul