Quizalize logo
placeholder image to represent content

How To Create A Date Hierarchy in Power BI

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    What is the first step to creating a date hierarchy in Power BI?
    Rename the existing date column.
    Identify the columns you want in the hierarchy (e.g., year, quarter, month).
    Load a sample dataset.
    Create a new calculated column.
    30s
  • Q2
    How can you create a new column for quarter in Power BI?
    Use the EXTRACT function with the syntax EXTRACT(QUARTER FROM [date column]).
    Create a new calculated column with a formula.
    Use the FORMAT function.
    Use the FILTER function.
    30s
  • Q3
    After creating the new quarter and month columns, what is the next step?
    Create a hierarchy from the highest level (e.g., year).
    Create a calculated measure.
    Change the data type of the date column.
    Add the new columns to the existing date column.
    30s
  • Q4
    How do you add a column to a date hierarchy in Power BI?
    Right-click on the column and select "Add to hierarchy".
    Drag the column onto the hierarchy.
    Edit the formula within the hierarchy.
    Use the DAX function RELATED.
    30s
  • Q5
    What visualization tool can be used to display the date hierarchy?
    A scatter plot.
    A pie chart.
    A table.
    A column chart.
    30s
  • Q6
    When drilling down on a column chart with a date hierarchy, what happens?
    The chart will sort the data.
    The chart will change its format.
    The chart will display a different data set.
    The chart will display more granular data based on the hierarchy levels (e.g., year -> quarter -> month).
    30s
  • Q7
    What is the benefit of using a date hierarchy in Power BI?
    It improves the performance of your queries.
    It allows you to easily analyze data at different levels of time granularity (e.g., year, quarter, month).
    It creates a new date column.
    It reduces the number of columns in your data model.
    30s
  • Q8
    Besides year, quarter, and month, what are other possible levels you could include in a date hierarchy?
    Filter context, background color, title.
    Customer name, product category, region.
    Salesperson, department, item code.
    Day, week, hour.
    30s
  • Q9
    How can you change the name of a date hierarchy in Power BI?
    Edit the formula defining the hierarchy.
    It cannot be renamed.
    Right-click on the hierarchy and select "Rename".
    Use the DAX function RENAME.
    30s
  • Q10
    What happens if you try to add a non-date column to a date hierarchy?
    Nothing will happen, the column will be ignored.
    The hierarchy will become corrupted.
    The column will be converted to a date data type.
    Power BI will display an error message.
    30s

Teachers give this quiz to your class