DATE/TIME HIERARCHY TABLE PROFILES

By utilizing this feature, you can incorporate the Date hierarchy in Power BI as a means to organize your data table, making it easier to drill down and carry out updates based on various time intervals grouped together.

Creation of Date/Time Hierarchy Table Profiles

After settling on the Power BI Table Profiles page ("Reports" "Insights Ready" section) and clicking "Add New Table Profile", users are presented with the option to choose the type of profile they desire, including the "Date Time Hierarchy" type, which can be selected from the dropdown menu.

Afterward, user is required to fill in 5 fields described below:

• Profile name -- set any suitable name for your profile.

• Type -- Date or Datetime, defines the data which is meant to be used in the dataset

• First Year -- set the year of the starting point for the data gathering

• Last Year -- set the year of the ending point for the data gathering

• Time granularity -- a measure of the level of detail which should be based on intervals of seconds, minutes or hours

After ensuring that all the fields are set correctly, you should click the "Save Profile" button on the top of the page.