🔥 40% Off Crucial Exams Memberships — This Week Only

3 days, 13 hours remaining!
Crucial Exams

Microsoft Azure Data Fundamentals DP-900 Practice Question

In Power BI Desktop you want to show total sales that automatically recalculates for whatever slicers or filters a user selects, but you also want to avoid adding extra stored data to the model. Which data-modeling feature should you create?

  • Add a calculated column to the Sales table that holds the running total.

  • Build a hierarchy that contains Year, Quarter, and Month levels.

  • Define a many-to-many relationship between the Sales and Date tables.

  • Create a DAX measure that returns the sum of the SalesAmount column.

Microsoft Azure Data Fundamentals DP-900
Describe an analytics workload
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot