Above is my Master Database with "countless" columns that I will never be able to use in my Data Model because none of my other tables will ever have all of the same headings.
This is my K-1 database from which I need to make a reconciliation report.
To the Pivot Table above, I need to pull the Date of Last Transaction from the Master Database for the names shown. How do I use that through the use of a Pivot Table measure?