Question 30
A Power BI team has this requirement: A dashboard requires a proper date from an ISO timestamp string with an offset and a separate calendar date for grouping. Which approach should it implement?
Explanation
Correct Answer
This directly addresses the stated constraint. Timestamp normalization must account for offsets before grouping by business dates. Confirmation: The resulting calendar day agrees with the business's timezone for edge-of-day events.
Incorrect Answers
Deleting the broken rename step without checking downstream references can corrupt measures. The specific problem here is that dropping the timezone before conversion can assign transactions to the wrong date.
Blindly converting the column to Decimal Number produces unexamined conversion errors. The specific problem here is that dropping the timezone before conversion can assign transactions to the wrong date.
Changing only the display format leaves mismatched underlying text/integer key types. The specific problem here is that dropping the timezone before conversion can assign transactions to the wrong date.