title: POWER BI - How to add manual columns/data to existing table instead of adding columns/data to the source csv file
body: <p>The picture I have attached shows what my power query table looks like (exactly the same as source file) and then underneath what I would like the final end product to look like.
  Correct me if I'm wrong but I thought the purpose of power query/power bi was to not manipulate the source file but do this in power query/power bi?<br>
  If that's the case, how can I enter new columns and data to the existing table below?</p>
  
  <p><a href="https://i.stack.imgur.com/7yRNr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7yRNr.png" alt="ORIGINAL TABLE VS END PRODUCT"></a></p>