Need oldest date in a Pivot Table from a separate table that I cannot add to the Data Model

Avra

New Member
Joined
Jul 1, 2020
Messages
24
Office Version
  1. 365
Platform
  1. Windows
Mr Excel Database.jpg

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.


K1 Database.jpg

This is my K-1 database from which I need to make a reconciliation report.


Capital Account Reconcilliation.jpg

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?
 

Attachments

  • Capital Account Reconcilliation.jpg
    Capital Account Reconcilliation.jpg
    18.6 KB · Views: 1

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
my 2 cents,
merge Master Database with K-1 database by Name in Power Query then try to use it in Pivot Table
but I am not a @Fluff :cool: sorry
 
Upvote 0
my 2 cents,
merge Master Database with K-1 database by Name in Power Query then try to use it in Pivot Table
but I am not a @Fluff :cool: sorry
Hi @sandy666

I guess I have homework. I'm new to Pivot Tables and have never used Power Query let alone know what it is all about :oops:. I already have Pivot Table Data Crunching by Bill Jelen so I'll start there. Any other resources that you can recommend?
 
Upvote 0
I'd start with 'M is for Data Monkey' by Ken Puls and Miguel Escobar - it is a great starter for PowerQuery, and PowerPivot and PowerBI by Rob Collie and Avichal Singh. I've learnt all I know about Powerquery and Powerpivot from those two books - and google!

HTH
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top