Adding columns You can add a new column in Power Query by using one of…