Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsEasy
A Power BI developer needs to add a new calculated column to an existing dataset in Power BI Desktop. The column should categorize sales based on a complex 'IF/THEN/ELSE' logic. In which view within Power BI Desktop should the developer create this new calculated column?
- AData view
- BPower Query Editor
- CReport view
- DModel view
Show answer & explanationAnswer & explanation
Correct answer: A. Data view
The Data view in Power BI Desktop allows users to see the data in tables, inspect and modify column properties, and create new calculated columns directly using DAX formulas. This is the most appropriate place for adding a DAX-based calculated column.
Why the other options are wrong
- B. Power Query Editor is for data transformation and M-language (Power Query) operations, not for DAX calculated columns on an already loaded model.
- C. Report view is for designing visuals and pages, not for adding calculated columns to the dataset.
- D. Model view is for managing relationships between tables and setting up RLS, not for creating calculated columns.
Power BI Desktop Data View
One of the three main views in Power BI Desktop, used for inspecting data, creating calculated columns and measures, and viewing table structures.
- Shows raw data in tables.
- Used for DAX formula creation.
- Allows column property inspection.
Memory trick: R-D-M, Report-Data-Model, know where to roam.