Forum Discussion
2 date fields in different table
having a calendar table makes your life much easier (because you get to use the time intelligence functions)
you can do those calculations without it but you'll have to write a bit more
look here at this link provided by Matt
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
I'm pretty sure that if you create a table of just dates and relate both Impressions and Forecast to it like in my model, you will get the correct lines.
Here is what is going on, it just dawned on me. Because there is no relationship between Forecast and Impressions, it is doing exactly what you said, it is simply summing one or the other (all of them) for every date because there is no context filter for date essentially. So the aggregation gets everything. That is why one is so much higher than the other and why it is the same number for all dates.
I am sure it will work if I create a table with the field "date" and add all dates in it but it does't make sense.
At that point, I would prefer to add a column in YTD table called forecast and paste the Forecast data in it.
I tried that too by doing that but again it add all the total impression forecasted as a total...
Imp_Served = SUM(Forecast[Forecasted impressions])