Afternoon all,
Ok so here's the situation. I have two data sources and I am blending them.
The primary data source is a table of current transactions. The transaction dates are populated as transactions happen throughout the year.
Example - Transactions started in Jan 2019 and are current through today - July 2019
The secondary data source is a table for forecasted spending amounts. The dates on this table run from Jan 2019 through Dec 2019.
The problem is that I cannot get the forecasted amounts (secondary source) to show beyond July 2019 because the primary source does not have a value.
What I am getting:
Primary Source Date
Secondary Source Date
Secondary Transaction Amount1/1/20191/1/2019$1.002/1/20192/1/2019$3.003/1/20193/1/2019
$5.00
4/1/20194/1/2019$7.005/1/20195/1/2019$9.006/1/20196/1/2019$11.007/1/20197/1/2019$13.00NullNullNullNullNullNull
What I want:
Primary Source Date
Secondary Source Date
Secondary Transaction Amount1/1/20191/1/2019$1.002/1/20192/1/2019$3.003/1/20193/1/2019$5.004/1/20194/1/2019$7.005/1/20195/1/2019$9.006/1/20196/1/2019$11.007/1/2019$13.008/1/2019$15.009/1/2019$17.0010/1/2019$19.0011/1/2019$21.0012/1/2019$23.00
You might be asking why don't I just make the secondary source the primary source? That's because the secondary source has so much more data in that table that I need for other calculations.
Thank you in advance for your help!
Scott
Deepak,
I cannot join the data because the primary table is a union combining 2 other data sources that are a many to many relationship.
That said, I figured out my issue and was just coming back to delete this post. I adjusted the data relationship and got the values that I needed.
Thank you,
Scott
