Forum Discussion
Power Pivot
Tengo un problema al cargar la tabla calendario en Power Pivot, ya que algunos archivos la cargan y otros no, ¿alguien de la comunidad me puede ayudar? Gracias.
Hello,
You can easily create a Calendar Date Table in the Power Pivot. No need to load Calendar.
In Power Pivot, click on Design > Date Table > New.
That will create automatic calendar.
Then, you can create a One to Many Relationship between the Date (Fact Table) and Calendar (Dim Table). With this, you can use the Time Intelligence functions to achieve your desired outcome
Cheers
You can easily create a Calendar Date Table in the Power Pivot. No need to load Calendar.
In Power Pivot, click on Design > Date Table > New.
That will create automatic calendar.
Then, you can create a One to Many Relationship between the Date (Fact Table) and Calendar (Dim Table). With this, you can use the Time Intelligence functions to achieve your desired outcome
Cheers
I appreciate your kind reply. The problem is that this is how I have been doing it, as you describe it, but from one moment to the next it stopped creating the calendar table automatically, in a few files it does, in others it does not; for this reason I need urgent help since I have not been able to continue with my learning. Thank you for your attention.