Date Dimension in power Pivot 2016

As you know when you work with data you have always need a Time dimension table .There are a number of ways of building these tables :

  • External data source like Azure Market place
  • Power Query
  • Excel File

In Excel 2016, you can get one built automatically inside the Power Pivot window.

You can create your date Dimension starting from other Table. For example if you have a Fact table of sales with date column loaded into the Data Model, when you go to the Design tab in the Power Pivot window you’ll see the new Date Table button enabled:

Menu

Clicking on the New button will add a new date table to the Data Model, called Calendar:

CalendarBasic

If you want to change date you have the option of manually configuring the range of dates used by clicking the Update Range button:

Range

If you do make changes like adding calculated columns, such as the Month Year calculated column shown below:

Calc

You can then click the Save Configuration button to save the current state of the table as your default.

 

Annunci

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...