Create calculated columns in power query RRS feed

  • Question

  • Is it possible to create calculated columns in power query? For example, I have sales $'s and sales units, and I would like to create an average sale price column calculating on each row. I know you can do this in power pivot but I need to do it before it's in power pivot model (I think) because I need to merge data sets and have them subtract from each other. 
    Monday, April 17, 2017 8:46 PM


  • Apparently you haven't discovered Power Query yet. Power Query is also known as "Get & Transform Data"  in Excel, so yes: adding columns is one of the core capabilities of Power Query.

    My suggestion would be to explore the options on the "Add Column" tab.

    Tuesday, April 18, 2017 3:37 AM