To create a colnumn

Hi AtchayaP ,

 

I suggest you to add a custom column by "IF" in Power Query Editor.

if [Type] = "Service 1" and [Environment] = "Prod" and [Type of Issue] = "Incident" then 1 else 0

Result is as below.

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.