Forum Discussion
Analyze in Excel
Thanks for your detailed reply, it was really helpful.
Regarding my setup, I have a table which is fed by my semantic model.
After adding the commentary column to this table, I duplicate the Query like you said and merge it by itself via my identifier.
But now both queries have the same source(my semantic model), is this correct?
Wouldnt a change in the rows affect the query which i use for the merge?
Thanks a lot!
My Table
Hey PBILix ,
You don't have to Duplicate the query: just add the additional data and commentaries to the Transformed table on your secondary sheet and then use it as a "Source" to create the temp table query.
You neet to merge the Transformed table on your secondary sheet (initial transformation query) with this "new" source on some UniqeID and it works.
Cristian