Snapshot data

Thanks Greg -

I had hoped posting the table would be enough.   But to elaborate:  

I have a date table with the "as of" date connected to the "dates" in the date table.  

I specifically need to connect to these particular accounts, but with the added challenge that our ERP system only reconciles the prior month on the 1st day of the next month.    So a final January number only becomes available the first day of February. 

Literally what I am trying to do is to achieve a measure that replicates the table below and shows the total sum  (which is cut off in the picture).    To do so, I somehow need to get at these specific accounts, and utlize the "create date" and the "as of" dates, and the "actual value".