Skip to main content

Power BI

Needs Votes

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

Miguel Llopis 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.