Skip to main content

Power BI

New

When appended queries automatically add a column to differentiate between the 2 query results

Vote (1) Share
Wade's profile image

Wade on 02 Jul 2016 02:27:20

When you append 2 queries it would be nice to know which rows came from which query after the fact with an additional column identifying them by the query name at the time they were appended.

Comments (1)
Wade's profile image Profile Picture

b5e35a47 3e1a-41fc-b812-411a49f78fdf on 05 Jul 2020 22:25:03

RE: When appended queries automatically add a column to differentiate between the 2 query results

Thanks for the suggestion - Note that you could achieve this today by adding a custom column with the Query Name (i.e. "Query 1") to each query, before performing the Append operation.