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.