Log In
Register
Home
New Member
Power BI
May 30, 2020
Offline
Hello,
I load some project data into an excel table from a powerquery. The data in the powerquery comes from a sql server view. Now the user wants to add an extra column 'Notes' in the excel table. This column is not part of the view/database table. The data is this column must be preserved and shown in the column as long as the project shows up in the result list of the view.
Is there a way to accomplish this?
Thank you.
Best regards,
Ruud de Heij
The Netherlands
July 16, 2010
Offline
Hi Ruud,
Welcome to our forum!
Because the query and the extra column are not from the same source, i.e. all from Power Query, there is a risk that the order of the data in the query becomes out of sync with the order of the notes.
Perhaps the safest way to keep them in sync is to add an index column to the query data and enter the notes in a separate table with the relevant index number that relates to the query data. Then load the notes table into Power Query and merge the two tables using the index number to match them up. That way the notes will always correspond to the correct row of the query, even if it gets sorted in a different order.
Mynda
1 Guest(s)
