Forum Discussion

bartvana's avatar
bartvana
Iron Contributor
Jan 09, 2021
Solved

Adding a column with custom values to a Power Query

I have in Sheet1 a table tProducts with products and quantities sold from the last 6 months (coming from SQL query from the company ERP). I now want to make a custom table tSS where I assign to each...
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 09, 2021

    bartvana 

    Please check in attached. I trim and lowcase product names to use them as ID, but if you data is clean it's not necessary.

Resources