Getting value from pivot

[guyinazo]

I have queries that pull in a file from yesterday and take the same file from today and list out any differences.  It is working.  The queries are pivots after the ID column.  One of the attributes is Name.  Is there a way I can reference the value from that attribute?  Even if it is a column, or measure, that is the name for that one record.  Thanks for the information

[amitchandak · Accepted solution]

@guyinazo ,If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

If you plan to compare power bi files you can use ALM toolkit

How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc