Power Pivot

[Ricardo777]

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.

[#2]

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

[#3]

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.

@Abiola1