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/
elatreille - I'm not understanding what you are asking "dates are in each table with the data". Yes, my model has dates in each table with the data. Can you explain a little more or post a screen shot of your tables or something?
You would not necessarily need a separate date table with just a list of all dates if one of your tables includes all of the dates that you care about and has no repeat values.
Your graph is exactly what I need. Here is what I have:
elatreille Your screen shot is very tiny, but from what I can tell, it looks like you are using measures in your graph, can you post the formulas to your measures? My guess is that therein lies the problem.
Sorry for the picture, for that metrics I am not using any measures, hope that screenshot is better
If that can help!
Well, first thing I would try would be to relate your Date from Forecasting to your Date in YTD. Then, I would see if you can drop down your Date column in your Axis and see if you can choose something like "Day". Is the format of your date something like:
1/30/2016
?
My X-axis is set to "Continuous" and "Linear" if that makes a difference.
Maybe one of those is a cumulative/running total? Why is the difference so much?
Try creating Runing Totals for each like so
Forecast RT = CALCULATE ( SUM(Table[Forecast], FILTER(ALL(Table), Table[Date] <=MaX(Table[Date]) ) )
Actual RT = CALCULATE ( SUM(Table[Actual], FILTER(ALL(Table), Table[Date]<=MAX(Table[Date]) ) )
I'll try that but to answer your question, depending the date I select, one will show and dupicate the total.
So if I select the date under forecast, I will have the forcast per day with no probelem and the impression served will be the total of all impressions, if I select the date under Impression served, I will have the impressions per day with no prob and the forecast will be the total forecasted impressions :(