Power Pivot

%3CLINGO-SUB%20id%3D%22lingo-sub-1487735%22%20slang%3D%22es-ES%22%3EPower%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487735%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20have%20a%20problem%20loading%20the%20calendar%20table%20into%20Power%20Pivot%2C%20since%20some%20files%20upload%20it%20and%20others%20don't%2C%20can%20someone%20in%20the%20community%20help%20me%3F%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1487735%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1487760%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487760%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20easily%20create%20a%20Calendar%20Date%20Table%20in%20the%20Power%20Pivot.%20No%20need%20to%20load%20Calendar.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20Power%20Pivot%2C%20click%20on%20Design%20%26gt%3B%20Date%20Table%20%26gt%3B%20New.%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20will%20create%20automatic%20calendar.%3CBR%20%2F%3E%3CBR%20%2F%3EThen%2C%20you%20can%20create%20a%20One%20to%20Many%20Relationship%20between%20the%20Date%20(Fact%20Table)%20and%20Calendar%20(Dim%20Table).%20With%20this%2C%20you%20can%20use%20the%20Time%20Intelligence%20functions%20to%20achieve%20your%20desired%20outcome%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1489769%22%20slang%3D%22es-ES%22%3ERe%3A%20Power%20Pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1489769%22%20slang%3D%22es-ES%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CSPAN%3EI%20appreciate%20your%20kind%20reply.%20The%20problem%20is%20that%20this%20is%20how%20I%20have%20been%20doing%20it%2C%20as%20you%20describe%20it%2C%20but%20from%20one%20moment%20to%20the%20next%20it%20stopped%20creating%20the%20calendar%20table%20automatically%2C%20in%20a%20few%20files%20it%20does%2C%20in%20others%20it%20does%20not%3B%20for%20this%20reason%20I%20need%20urgent%20help%20since%20I%20have%20not%20been%20able%20to%20continue%20with%20my%20learning.%20Thank%20you%20for%20your%20attention.%3C%2FSPAN%3E%3C%2FPRE%3E%3CP%3E-ERR%3AREF-NOT-FOUND-%40Abiola1%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted
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
Highlighted

 

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