Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Snapshot data

Hello Community - Below is a modified sample of data extracted from our ERP system.    The accounts (40000, 40010, etc) are general ledger accounts.   In order to get a Month to Date value, in this c...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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".