I am working on data set that is imported via Salesforce Objects into Power Query. On one of my queries I'll have a table that has a column for Department Owner. Then I'll create another table for a different report within the same Power Query but this table will not have a column for Deptartment Owner.
Is it possible to create a new column for Department Owner on this new table, auto filling in or matching the User to their correct department?
I would be more than happy to provide additonal information or demonstrate.