Crucial Exams

Microsoft Power BI Data Analyst Practice Question

Your Power BI model ingests an Orders table from a legacy source where the OrderID encodes the order date as yyyymmdd-xxxx (for example, 20230115-0421). You must let report developers use DAX time-intelligence functions such as TOTALYTD against order revenue. The data source cannot be modified. In the model, what should you do?

  • Use a quick measure that calls TOTALYTD after wrapping OrderID in VALUE and LEFT functions each time the measure is used.

  • Create a calculated column in Orders that parses the first eight characters of OrderID into a Date data type and use that column in relationships and measures.

  • Build a calculated table that aggregates Orders by the encoded date and relate it to the Orders table with a one-to-many relationship.

  • Enable the Auto date/time option so Power BI automatically creates a hidden date table from the OrderID column.

Microsoft Power BI Data Analyst
Model the Data
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