Forum Discussion
Solved
2 date fields in different table
Hi everyone, I am new to Power BI and I will need some help here. I have 3 tables where one is a middle one and the two others has the full data. In the first table I have historical data and in ...
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 have three tables:
ImpressionDates
Date
| Tuesday, April 26, 2016 |
| Wednesday, April 27, 2016 |
| Thursday, April 28, 2016 |
| Friday, April 29, 2016 |
| Saturday, April 30, 2016 |
Sunday, May 1, 2016 |
ImpressionsServed
DateImpressions
| Tuesday, April 26, 2016 | 100 |
| Wednesday, April 27, 2016 | 200 |
| Thursday, April 28, 2016 | 300 |
| Friday, April 29, 2016 | 250 |
| Saturday, April 30, 2016 | 275 |
| Sunday, May 1, 2016 | 300 |
ImpressionsForecasted
DateForecast
| Friday, April 29, 2016 | 225 |
| Saturday, April 30, 2016 | 300 |
Relationships are:
Visualization is:
Ok, I get that but what if my dates are in each table with the data...
Do I need to have a table with the field date and fill it with each date of the calendar?
Each table have around 500 lines.
Thanks
Eric